Forum Discussion
Simple Relationship Build Issues
Hi All, I think this is probably a very simple problem I am struggling with! I have 3 different spreadsheets containing the same column headers but different information. On my Dashboard I w...
Wimverh
Resolver IV
Resolver IVIn transform/Edit quereis you have to do 2 extra steps
1. Add an extra column to your dataset, for example: Source
for Life Extensions -> source field with fixed value Life Extensions
for CSF -> source field with fixed value CSF
2. Append Life Extensions with the other 2 tables
see this link: append queries
In the datamodel, only load your Life Extensions table, which will contain all 3 files.
You can add a filter on Source to display it for 1, or a combination.