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: 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...
Need Help
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.