Forum Discussion

cflynn_29's avatar
cflynn_29
Helper I
3 years ago
Solved

Fill down Columns based on Column List

I have a table that has quite a few columns and i need to fill down only columns that contain the "RCCD" name.   So my next step was to use = Table.ColumnNames(#"Promoted Headers1") and it gi...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi cflynn_29 - you don't need to include the Table.ColumnNames function because "Custom8" is a list.

     

    #"Promoted Headers1" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
Custom7 = Table.ColumnNames(#"Promoted Headers1"),
Custom8 = List.FindText(Custom7,"RCCD"),
Custom9 = Table.FillDown(#"Promoted Headers1", #"Custom8" )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi cflynn_29 - you don't need to include the Table.ColumnNames function because "Custom8" is a list.

 

#"Promoted Headers1" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
Custom7 = Table.ColumnNames(#"Promoted Headers1"),
Custom8 = List.FindText(Custom7,"RCCD"),
Custom9 = Table.FillDown(#"Promoted Headers1", #"Custom8" )