Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
Just create a new step before your append steps. ( In Applied Steps over on the right in PQ )
@danextian that sounds like a good idea but unfortunately I have already done append
Just create a new step before your append steps. ( In Applied Steps over on the right in PQ )
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.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
52 | |
41 | |
39 | |
37 |