Dynamically splitting one Source Table into multiple separate query tables?

[Cayshin]

So I have a query table such as:

Title	Column 1	Column 2
A	random data	random data
A	random data	random data
A	random data	random data
B	random data	random data
B	random data	random data
B	random data	random data
B	random data	random data
B	random data	random data
C	random data	random data
C	random data	random 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.

[ChenwuZhu_Gmail]

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.