Calculate ODD

[johnan]

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 🙂

[MayilVahanan · Accepted solution]

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.