How to declare data into True and False?

Hi !! This is a little urgent, I have a dataset as below.

Apples
Banana
Orange
Watermelon

I would like to declare Apple and Banana to as True, Orang and Watermelong as False.

Desired output:
Apple | T
Banana | T
Orange | F
Watermelon | F

Looking forward to get a reply soon!! Thankyou super much !!!

hi @KainLittleCloth
Create a table with two columns: unique names | boolean, e.g.

Apple | true
Banana | true
Orange | false
Watermelon | false

Join your dataset to this table on the fruit name using the Joiner node

2 Likes

Hi @KainLittleCloth

You can also use a RuleEngine node, configured like this:

> $column1$= "Apples" => "T"
> $column1$= "Banana" => "T"
> $column1$= "Orange" => "F"
> $column1$= "Watermelon" => "F"
> TRUE => "don't know yet"

gr. Hans

4 Likes

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