I have like 3 Fact tables (no join/concanate) and for each of them I have a "bla bla AS Source..", so I end up with Source A, Source B, Source C, but the content is the same and there is several choices that the user needs to choose from.
At the front-end I need to put them together so the user only have one listbox, "one set of content". I cannot see how the concat can help here.
What is the correct solution for this? and of course I am concerned that the datamodel still work.
If only the content of the source-variable is the same,and not the whole fact table, then you load all tables, and just rename the Source variable in all 3 with the same name, without concatenating
Then you 'qualify' each table. Looking at your request however, I don't see why you would not concatenate all 3 tables if they have all three the same information or the same fields. By concatenating, you won't lose any data, the program just puts all three tables together. Look at it as putting data from 3 separate excell sheets into one sheet. You won't lose any columns, your number of rows get bigger.
If possible, then please describe your variables in your 3 tables, and why they should keep separate.
Concatenating fact tables is easy if they contain the same content. Other fields and data shouldn't have any effect on that. But if you think that it cannot be done then perhaps you shouldn't try at all and create three separate documents instead.
