Reference Query as a Table in a Row

[JustDavid]

I have a query name 'tblData' which is a table (has columns and rows).

My question now is that, in a new query, how can I reference this tblData and make it into a 'Table' data type in a row (as seen in print screen)?

Reason I ask is that, it seems that when it's in 'Table' data type, doing Table.TransformColumns seems to be faster.

[jgeddes · Accepted solution]

The table constructor should do that for you...

= #table({"Data"}, {{TableName}})

Replace TableName with the name of the table being referenced.

[PwerQueryKees]

Not sure what you are trying to achieve, but you can use a Table just like any other value, a number for example.

so to add a column containing your table in every row to your current table:

=Table.AddColumn(Source, "My Table Column", each tblData)

If you do a group by and select "keep all rows" as the aggregation, it will also produce a field with tables in it. Different tables, because each table will only have the rows belonging to the current groep.

Did I answer your question? Then please (also) mark my post as a solution and make it easier to find for others having a similar problem.
Remember: You can mark multiple answers as a solution...
If I helped you, please click on the Thumbs Up to give Kudos.

Kees Stolker

A big fan of Power Query and Excel