How to add a column showing datasource

[Susan585]

Hi there ~ I am pulling data from multiple datasources. How can I add a column that shows the datasource, such as the SQL Server and the Database name?

[AKNiang]

Hi,

If the sources are few you can add a custom column with the name of the source.

Add Column --> Custom Column --> Name the column as "Source" and then give the source name for example "SQL" with the double quotes as it's text.

If I replied to your question please consider to close the question

[Susan585]

Thank you, but I do not see how that will pull in the name of the SQL Server or Database where the data is coming from...?

[jbwtp · Accepted solution]

Hi Susan,

it won't pull the names, but PQ doesnot support "unanimous" datasources. Even if you load them dynamically, you know at any point in time what are they, right?

From this perspective, this is "add column" with either "static" name (which you can enter manually as this is hardcoded in the query) or "dynamic" (which you can add as part of the query, assiging it to a variable/step and using it as the Table.AddColumn statement.

Cheers,

John