Forum Discussion

powerbricco's avatar
powerbricco
Advocate 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

Mauro89's avatar
Mauro89
Super User
5 months ago

Hi powerbricco,

 

I thing this totally depends on the data source you are using and what is the "Source.Name" what you are looking for.

E.g. if you have a warehouse or lakehouse as source you can filter by the corresponding artefact (delta table, MV,...) in the "Navigation" steps when you add the data source.

 

Hope this helps to get into the right direction!

If not feel free to share a bit more content like data sources and PQ structure.

 

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution