Capture column names and data types from an earlier step in a query

Yes, you can refer to any other step in the query, whether before or after the current step, and it will return a table, list, value, whatever it might be. So NewStep = ThreeStepsAgo will return ThreeStepsAgo, and if it's a table, you have a table. You can also do

NewColumns = ThreeStepsAgo[[Column1], [Column5], [Column9]] to return the table step with only certain columns.

--Nate

Hi JimJaggers,

You don't need to work hard to do that. You can simply use the existing table type. Like this:

let
    Table1 = #table(type table [Num=Int64.Type,String=text], {{1, "One"}}),
    Table2 = #table(type table [String=text], {{"two"}}),
    AlternativeOutput = #table(Value.Type(Table1),{{0,"Zero"}}) 
in
    AlternativeOutput

Showcase Report – Contoso By SpartaBI