Forum Discussion

Cayshin's avatar
Cayshin
Frequent Visitor
4 years ago

Dynamically splitting one Source Table into multiple separate query tables?

So I have a query table such as:

TitleColumn 1Column 2
Arandom datarandom data
Arandom datarandom data
Arandom datarandom data
Brandom datarandom data
Brandom datarandom data
Brandom datarandom data
Brandom datarandom data
Brandom datarandom data
Crandom datarandom data
Crandom datarandom data

 

Is there a method to automatically split this query into seperate queries for each unique Title?

So in the above example, I would end up with 3 query new tables: A table of just rows with a Title of "A", another table with just "B"s, and a third table with just "C"s.

In actual practice, there could be a dozen or more unique Titles.

 

The overall issue I have is that the random data in Column 1, 2, etc... is just that: random. It's a mix a true/false, interger, string text, dates with each data type determined by the Title (so "A"s might be true/false, "B"s might be string text, etc). The inconsistent data types obviously prevent using any functions that rely on it such as SUM() or Date Hierachy. Some of the seperated queries may require further customization so it'd be nice to have them already pulled out to modify.

 

Thanks in advance.

Need Help

1 Reply

  • ChenwuZhu_Gmail's avatar
    ChenwuZhu_Gmail
    Resolver I
    4 years ago

    Hi Cayshin ,

     

    Maybe you can try use Group by to group the original table.

     

    Then create an invoke function via Blank Query to create a new table.

    invoke function:

    let
    Source =  (x as number) => 
    let 
    tbl = #"Table"{x}[_table]
    in 
    tbl
in
    Source

     

    Then if you enter a number and invoke, it will create a new table.

     

    Best regards.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.