Forum Discussion
How to add a column showing datasource
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
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...?
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