Forum Discussion

dmarics28's avatar
dmarics28
Frequent Visitor
6 years ago
Solved

Trying to create a new column based on the query or source file name.

Hi Guys, I am trying to create a simple new column in my dataset. But I need the data to be the Query name. What is the formula for Query Name? Or Source File name? Thanks in advance.    ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi dmarics28 ,

     

    Try to change the code of your Append query in the Advanced Editor.

    let
    Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A")
                            , Table.AddColumn(#"query B", "source query", each "query B")
                            , Table.AddColumn(#"query C", "source query", each "query C")})
in
    Source

     

    BTW, .pbix file attached.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dmarics28's avatar
dmarics28
Frequent Visitor
6 years ago

BA_Pete 
Almost! : ) So close!

When i go to apply it to the model, i get this error.

 

 

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
6 years ago

dmarics28 ,

 

Yes, unfortunately #sections and #shared are Power Query environment only. I should have checked your use-case first.

In terms of carrying the appended query names over, on balance of time/effort, I see your options as follows:

 

1) Manually add a column into each of your PRE-APPENDED tables, like ="myTableName1", ="myTableName2" etc. Ensure these columns have the same field name and data type in each table and the append process will bring them in correctly the same as all the other data columns.

2) Use your data source to create a 'Source Name' table that is bundled with the main data table. For example, in Excel you could create another tab that just contains the name that you want the source to be called. Bring this table in with the main data and then use it as a source to reference in an added column in Power Query. In reality, this essentially achieves the same as option 1), but in a far more roundabout way.

 

Pete