Power query question

[STIRRELL]

Hi all I would like to use the append function in power query to combine 3 spreadsheets. When I do this manually in the last column I type the type of activity the report contains. Such as booked, shipped, logged. Then this is put into a pivot table. So my question is when I am import the different speadsheets is there a way to update the last column with the type. ( booked, shipped, logged)Each spreadsheet is dedicated to the type . shipping report is dedicated to shipping. Or is there another way To do this. The spreadsheets are huge so I am looking for a better way to consoolidate, but the name of the type is critical amped is not in the data.
thanks so much
sharon

 

[alansidman]

is there anything in the tables that will dictate the last column? That will be what is needed. Add a column and create an if then statement to populate the new column. Before appending the sheets, you may want to add the column based upon the type of sheet is another way.