I have multiple tables from a SQL source. These tables have exactly same column and fields, so Qlik sense automatically combine the fields. However, when this happen I cannot identify the data by it's specific table anymore (none of the fields has unique values to the tables). I've tried using Qualify instead in my load script, which enable me to separate the tables by its name, but then I'm unable to apply one common filter for all the tables. For example, when I'm trying to find a name, I want to be able to see if the name appears in different tables or not. Would appreciate advice on this, thanks!
To concatenate (union in sql) all these tables with unified field-names into a single table is the right way. The only thing you are missing is to add an extra source-field, like:
final: sql select F1, F2, 't1' from t1; concatenate(final) sql select F1, F2, 't2' from t2;
