assume we have a datasource table that contains 4 columns i-e
ASIN SKU Available AMZ_Available
ABC DEF 100 4
XYZ HIJK 200 5
Now In Qlik I've created 2 different tables in a following way
Table1
ASIN SKU Available
ABC DEF 100
XYZ HIJK 200
Table2
AMZ_Available
5
4
As you can see in table2 values are in the order as in table1 i-e ASIN value ABC belongs to value 4 in table2. So I want to sort this order correctly in both tables that means my table2 order should be