Forum Discussion

powerbricco's avatar
powerbricco
Icon for Advocate I rankAdvocate I
5 months ago
Solved

PQ - Create a column if Source.name column begins with

Dear All, i want to add a step in powerquery that creates a column only if Source.Name begins with letter "a". Tha is beacuse my importing mode is changed. From now on, my Source.Name is different ...
Need Help
  • nathancwatkins's avatar
    nathancwatkins
    5 months ago

    You could add a query and make a list using Table.ColumnNames(QueryTableName), then make it a table, and then add extract the first letter of each column. Then you could make a reference query for the Table Query, and make a condition like if List.Contains(ColumnNameTable[ExtractedFirstLetterColumnName], {"a"}, then Do.YourTransformation, else Do.YourOtherTransformation.

     

    You'll need to replace my table and column names to your own, but that's the idea.

     

    --Nate

nathancwatkins's avatar
nathancwatkins
Icon for Helper II rankHelper II
5 months ago

You could add a query and make a list using Table.ColumnNames(QueryTableName), then make it a table, and then add extract the first letter of each column. Then you could make a reference query for the Table Query, and make a condition like if List.Contains(ColumnNameTable[ExtractedFirstLetterColumnName], {"a"}, then Do.YourTransformation, else Do.YourOtherTransformation.

 

You'll need to replace my table and column names to your own, but that's the idea.

 

--Nate