Forum Discussion

phull543's avatar
phull543
Frequent Visitor
3 years ago

Add column to display name of data source

Hello, I need to identify the data source in a table because I am going to append queries and combine all the queries listed on the left into one table. So I want to implement a column to identify each data source so that when I am displaying the appended querie in one table I can filter that table by brand name. So for example I have a query called CRENDON, I need to add a column that identifies it as such. All help is appreciated. 

 

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi phull543 ,

     

    There's no OTB way to do this in Power Query.

    If your queries are fixed on those brands, then I'd suggest either:

    In Power Query add a new custom column:

    = "CRENDON"

    ...or in the native query:

    SELECT *, 'CRENDON'
FROM ~

     

    Pete