Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Test.Combine with List

Dear all,   I have a table with a lot of culumns, and I want to combine them in a dymamic way.   I am using then the following instructions:   Dollars_Columns_Selected_DOLLAR_Source1 = List.Sel...
Need Help
  • ZhangKun's avatar
    ZhangKun
    1 year ago
    Helper_Source1 = Table.AddColumn (
	Total_Sales_DOLLARS_New_Name_Source1,
	"Helper_Source1",
	each Text.Combine(
		List.Transform(HeaderDifference_Source1, (fn) => Record.Field(_, fn)), 
		""
	)
)
ZhangKun's avatar
ZhangKun
Super User
1 year ago
Helper_Source1 = Table.AddColumn (
	Total_Sales_DOLLARS_New_Name_Source1,
	"Helper_Source1",
	each Text.Combine(
		List.Transform(HeaderDifference_Source1, (fn) => Record.Field(_, fn)), 
		""
	)
)
Mic1979's avatar
Mic1979
Post Partisan
1 year ago

Perfect. Many thanks.