Discussion board where members can get started with Qlik Sense.
I have 4 tables:
Tables consist all the mainorder from table2 to table4.
How could I combine these table into 1 table?
Go for Concatenate, and for data filtration purpose you can create one flag for each table while concatenating
I assume the MainOrder in every table is distinct, so I reccommend the following logic:
null() as SalesAmount
null() as Cost
So concatenate all tables, as Agnivesh Kumar suggested, and create a sum of SalesAmount to filter out the possible duplicates.
These tables do concatenate default. Just load and see in Model Viewer. Are there any Synthetic Keys formed?