If Condition

[markgraham123]

Hi all,

I'm stuck at a point where i have ID and other filed CHDLM

I wanna add a new dimension which says 'X' category, if an ID has 'X' in its CHDLM field.

In the end, i wanna remove all the CHDLM fileds with 'X'. So, i can see whether the ID belongs to 'X' category or not.

Please find the attached application.

Any help is highly appreciated.

[sunny_talwar]

If X is always going to be the last character, then Yes

[Anonymous]

i ´m glad it helped