I have 5 data tables that are very similar. The only difference between them is the title. All of the columns are the same. I need a unique variable in each of the tables so when we pull all the data into a single table to reference we can determine which table it was pulled from.
I'm not sure the best way to accomplish this. I was thinking of using the insert function but that seems to insert something in the place of something already there. We need to create a brand new variable across the whole data table.
Thanks for any help.
Please sign in to leave a comment.