i have two tables with item codes:
Table 1: (all item codes of system)
Table 2: (all marketing campaign item codes)
I need one table with all item codes and the classification campaign product or not (Cross Sale)
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
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)
Use Rule Engine node. With expressions
IF $T1_Item_code$ = 1 OR $T1_Item_code$ = 3 => “campaign”
TRUE => “Cross Sale”
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
Then use Joiner node with Left Outer Join. Join T1 with T2 and use added column from T2 instead of T1_Item code.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.