Create a table with product classification campaign/Cross Sale

Hello,

i have two tables with item codes:
Table 1: (all item codes of system)
item code
1
2
3
4

Table 2: (all marketing campaign item codes)
item code
1
3

I need one table with all item codes and the classification campaign product or not (Cross Sale)
Result table:
item code / classification
1 / campaign
2 / Cross Sale
3 / campaign
4 / Cross Sale

Which notes can i use to create the result table? Hope someone clould help me. Thanks regards Chris

Hi @Chris87,
there are many different ways you could do this!
I prepared a workflow that starts by classifying the campaign column, joins both tables on the item code, and defines the Cross Sales Items through either the Rule Engine or the Missing Value Node.
I would prefer the Rule Engine since it is more flexible and can apply many more Rules. The Missing Value Node works if there are only two cases of classification.
I hope this helps!
Create a table with product classification.knwf (14.1 KB)

Best regards,
Felix

2 Likes

Use Rule Engine node. With expressions
IF $T1_Item_code$ = 1 OR $T1_Item_code$ = 3 => “campaign”
TRUE => “Cross Sale”

Hi izaychik,

thanks for your advice, but i need a note for more item codes. This is only an example. In the real tables i have over 500.000 items. Some advices? Regards Chris

@FelixFelicis thanks sounds good. Perfect it works. Regards Chris

2 Likes

Then use Joiner node with Left Outer Join. Join T1 with T2 and use added column from T2 instead of T1_Item code.

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.