Replace values in a columns without affecting the other values in the same column

[DanySB89]

Hi guys!
Being learning a lot about knime, but I am having a hard time trying to process this step. I have to apply 2 filters in 2 columns in order to find a specific value I have to replace.

STEP:
Filter the “Media” column with “Mobile App” values, and then filter the “Property” column with “YouTube App” values.
Them in the resulting data after those 2 filters are applied, go to the “Media” column and replace the "Mobile App” values for “Mobile App Video”.

So easy to process in excel, but knime is killing me. I have tried some nodes that result in affecting the other values that are NOT supposed to be affected in that “Media” column. In these other values that are not supposed to be affected, knime transform then into the red missing value icon, but I need them to remain the same as they were before applying the rule to the “Mobile App/YouTube App” values.

Any suggestion about how to do it?

Just in case for reference, this is the file I am using.
Farmers_nonTV___oct_23_1034953 - Copy.xlsx (2.7 MB)

Thank you!

[kamtaot]

Hi @DanySB89,

Please check this.

Media_YouTube_Filter.knwf (2.3 MB)

Using Rule Engine you can put the below code to achieve the same.

$MEDIA$ = “Mobile App” AND $PROPERTY$ = “YouTube App” => “Mobile App Video”
TRUE => $MEDIA$

[DanySB89]

Hi!

It worked perfectly!

Thank you!

[kamtaot]

Hi @DanySB89, Happy to know that it worked for you.

Also, I want to say that it is easier in Knime compared to excel . Added advantage is that you can use it countless number of times without manual intervention if the input data format is same.

[DanySB89]

Thank you again for the great help!

I have been learning Knime since just 2 or 3 weeks ago, so some nodes are still new and unknow for me, but for sure this is x100 easier than excel once things are learned. I was already able to automate 3 big reports I usually process manually.

Thank you again!!

[kamtaot]

Hi @DanySB89 , Oh that’s great to hear that were able to automate some reports already. The support from the community is great here. I too learned with the help of this community. So, go ahead and post in case you could not find a solution immediately.