String Manipulation multiple columns follow up

[taylorpeter55]

Hi @takbb,
I hope you don’t mind me tagging you directly.

I found the below forum post which is the closest I have come to solving my particular issue.

rule engine multiple columns

[Screenshot 2023-05-28 174305] I have a dataset with binary variables of multiple columns. I would like to change “0” to “no” and “1” to “yes” but as the rule engine enables only one column I couldn’t make it. I tried with String Manipulation ( after converting the numbers to string) but it gives me error each time. Please help me, thanks. Ada

Within a loop, I need check the value in a series of string columns and if the value equals exactly ‘%’, I need to replace it with a missing value or Null.

Other rows in the same columns may include the ‘%’ sign and I need to keep these as is (Example data below).

Using your example, i’ve updated the expression as below which successfully recognises the % and replaces it (see screenshot below) :

string(
$$CURRENTCOLUMN$$.equals(“0”)
?“”
:$$CURRENTCOLUMN$$.equals(“1”)
?“yes”
:$$CURRENTCOLUMN$$
)

However, in your expression, I don’t actually need the section that returns the value ‘yes’. I just need to keep the value that was already present. I’ve tried to re-write the ‘yes’ section of the expression to reflect this, in addition to trying other variations of it, but i keep encountering errors.

If possible, do you know how can i update the expression to achieve the desired result please?

Thanks in advance for your help.

Pete

[takbb]

Hi @taylorpeter55

Yes this should be achievable. Instead of the line
?"yes"
use
?$$CURRENTCOLUMN$$

So in fact the entire equivalent to replace “%” with empty string and leave everything else, would be:

string(
$$CURRENTCOLUMN$$.equals("%")
?""
:$$CURRENTCOLUMN$$
)

and if you wanted it to have it return null (missing) rather than an empty String:

string(
$$CURRENTCOLUMN$$.equals("%")
?toNull("")
:$$CURRENTCOLUMN$$
)

[taylorpeter55]

@takbb,

Thanks so much - your help is greatly appreciated.

I’ve marked this as the solution.
Thanks
Pete