What tables have been appended

[stribor45]

I appended table #2 and table #3 to table #1.  When I edit the query for table #1 I don't see that anywhere. I mean data is there I'm just curious if there is a way to track this?

Thanks

[stribor45]

@danextian that sounds like a good idea but unfortunately I have already done append

[CoreyP · Accepted solution]

Just create a new step before your append steps. ( In Applied Steps over on the right in PQ )

[danextian]

Hi @stribor45 ,

For each table that you append add a column called Source or any other name to the original table. The input is the name of your source say "Table 1". There should now  be a Source column in the combined table. Load this into the model together with the other columns.