title: Is there a way to add columns to programatically to multiple queries?
body: <p>I have 24 queries from a pdf documents with data I want to transform. I want to append all the queries into a single one with all the data, but I would like to keep record from which query each line comes from. My idea was to add a custom column with just a id number to each query before appending them, but I would like to know if there a way to do this programmatically in power query so I don't have to go table by table?</p>