Forum Discussion

Alexander24's avatar
Alexander24
Icon for Helper II rankHelper II
8 years ago
Solved

M function to create new tables from list column with table values

Hi

 

I have used the table.partition function to create a list where each row contains a table partitoned by month,

 

I know want to automatically expand each table value in each row into a new table,

 

I am doing this as a semi automatic incremental refresh, i.e i just turn off enable load for each month once the month has gone

 

Doing it this way instead of duplicating the source query and hardcoding filters,  so that way If i change my source query, I only need to change it there and not just create new tables and change the filters every time

 

Thanks

Alexander

  • Anonymous's avatar
    Anonymous
    8 years ago

    Alexander24,

    I am afraid that you would need to right-click on each row and select "Add as new query".

    Regards,

    Lydia

3 Replies

    • Alexander24's avatar
      Alexander24
      Icon for Helper II rankHelper II

      Hi

       

      No worries, I was just going to turn off all the months but the current month manually every month,

       

      The company wont buy premium yet so I cant do that,

       

      Thanks

      Alexander

      • Anonymous's avatar
        Anonymous
        Not applicable

        Alexander24,

        I am afraid that you would need to right-click on each row and select "Add as new query".

        Regards,

        Lydia