Forum Discussion
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 and the file is missing a column, so my transformations are messed up.
thank you a lot
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
3 Replies
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
Hi powerbricco , Could you please elaborate your requirement with some examples ?
ThanksYou 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
