Forum Discussion

PowerBiKing's avatar
PowerBiKing
Frequent Visitor
3 years ago
Solved

Add identifier column before appending queries

Hi,

 

I'm bringing a PDF into Power BI that contains 3 tables that I would like to append to create one "master" table. All of the columns match up, and I can append the data as needed with no issue. However, I need a column in the new "master" table that identifies each row's source table.

 

I want to add a column called "Source" to the query for each of the source tables, of which every value will correspond to that source. E.g. the every value in the "Source" column in Table 1 of 3 will be "Table 1" etc. My thinking is that when I append the 3 tables, I will be able to differentiate which table the data originally came from using the "Source" column.

 

I'm relatively new to this, so I may be missing something obvious but I'm struggling to do this, as there doesn't appear to be a way to add a column with manual values to a table?

 

I should add that I can't add the identifying column before processing as I am not the publisher of the PDF, and it is updated weekly.

 

Example of the logic:

 

Table 1

Source (to add)2021 Value2022 Value
Table 1345546

 

Table 2

Source (to add)2021 Value2022 Value
Table 2456123

 

Master/appended table

Source (to add)2021 Value2022 Value
Table 1345546
Table 2456123

 

 

Thanks

 

  • Hi PowerBiKing ,

     

    I may be missing something here, but can't you just add a new custom column to each query with the calculation = "Source 1/2/3" ?

     

    Pete

2 Replies

  • Hi PowerBiKing ,

     

    I may be missing something here, but can't you just add a new custom column to each query with the calculation = "Source 1/2/3" ?

     

    Pete

    • PowerBiKing's avatar
      PowerBiKing
      Frequent Visitor

      Ah yes thank you!

       

      When I tried this earlier I couldn't get it to work (think I missed off the quotations) and I assumed that you couldn't just hard code it.