Hi,
I create Query in PQ by choosing source as Excel sheet.
How can I add Custom Column with sources' sheet name in each row?
...or
the same but Table name when creating Query from Excel table.
thanks
Hi,
I create Query in PQ by choosing source as Excel sheet.
How can I add Custom Column with sources' sheet name in each row?
...or
the same but Table name when creating Query from Excel table.
thanks
Any suggestion?
Add a custom column, and the formula for example: = "sheet name"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks