Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, got 2 tables
Table 1: This conatains just ordernumber, articles and quantity on order
Table 2: This contains article data type, length, hight, wieght and casepack
I want in my script identify all rows from table 1 that not equal to the case pack, let me illustrate:
From table 1:
1.Ordernumber 455, article 12222, quantity 3
2.Ordernumber 455, article 12222, quantity 6
-----------------------------------------------------------------
Table 2 contains
Article 455, Casepack 6
-----------------------------------------------------------------
So now in my script a will mark row 1 with 'ODD' and row 2 with 'EVEN'
Are you with me 🙂
Hi @johnan
T1:
Load * from Table1;
Join(T1)
Load Article, Cashpack from Table2;
Load *, if(Cashpack = Quantity, 'Even', 'Odd') resident T1;
Drop table T1;
Hope it helps.
Hi @johnan
T1:
Load * from Table1;
Join(T1)
Load Article, Cashpack from Table2;
Load *, if(Cashpack = Quantity, 'Even', 'Odd') resident T1;
Drop table T1;
Hope it helps.