Forum Discussion
Solved
Expand table using column name and not text value
Hi I have this syntax which works great and allows me to expand all columns from a merge table named 'TechRates' that start with "UK" #"Merged Queries" = Table.NestedJoin(#"Filtered Rows2", {...
Hi Richard_Halsall,
Do all rows in the ABC Division column of the base table contain the same text?
If so, try this to get the initial value: BaseTableName{0}[ABC Division] this syntax can also be generated by the UI when drilling down into a cell's value.
DocColumnList = List.Buffer(List.Select(Table.ColumnNames(TechRates), each Text.StartsWith(_ , BaseTableName{0}[ABC Division]) ))I hope this is helpful
Hi Richard_Halsall,
Do all rows in the ABC Division column of the base table contain the same text?
If so, try this to get the initial value: BaseTableName{0}[ABC Division] this syntax can also be generated by the UI when drilling down into a cell's value.
DocColumnList = List.Buffer(List.Select(Table.ColumnNames(TechRates), each Text.StartsWith(_ , BaseTableName{0}[ABC Division]) ))
I hope this is helpful
Many thanks that worked perfectly
