Forum Discussion
Filtering table before expanding column
I would proceed like this:
Table.addcolumn (# "Choose columns", "Company", each Table.SelectRows (_ [PBI_Change_Log_Entries], (r) => r [Table_Caption] = "Vendor Bank Account"))
instead of
# "Renamed columns" = Table.RenameColumns (# "Choose columns", {{"Name", "Company"}}),
then you delete the [name] column and finally expand the [Company] column.
I couldn't test the code, so pay attention to syntax and name matching.
I would proceed like this:
Table.addcolumn (# "Choose columns", "Company", each Table.SelectRows (_ [PBI_Change_Log_Entries], (r) => r [Table_Caption] = "Vendor Bank Account"))
instead of
# "Renamed columns" = Table.RenameColumns (# "Choose columns", {{"Name", "Company"}}),
then you delete the [name] column and finally expand the [Company] column.
I couldn't test the code, so pay attention to syntax and name matching.
Thanks, exactly what I needed