Linking two tables, first in first out - Qlik Community

Report Inappropriate Content · ‎2016-01-06

Hello,

I want to link 2 tables and show the result in a chart, fifo wise:

Is there a way I could manage this?

Thanks in advance!!

Gysbert_Wassenaar · ‎2016-01-06

This assumes your tables are already in the order you want:

Result:

LOAD

Article,

qty,

autonumber(RecNo(),Article&1) as Row

FROM Table1;

JOIN (Result)

LOAD

Article,

Salesprice,

autonumber(RecNo(),Article&2) as Row

FROM Table2;

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2016-01-13

Hello,

Thanks for this idea, but unfortunatly the tables in the right order.

My result for this example is now:

Gysbert_Wassenaar · ‎2016-01-13

Apparently the counters to the autonumber function need to be more different. I've edited the solution above to reflect this.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2016-01-14

Hi Gysbert,

Everything worked out fine! Thank you