Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

adding a flag- Reglex /Text to columns

Hi2023
8 - Asteroid

Hi,

 

I need to add a flag to certain files by adding a few words in the end of comment column.

 

For the column I am adding to -has difff lengths of dates, words, etc. 

Ex of one: 

Date(s) Received: 201912-22, 2027-03-17, 2020-03-29, 2000-06-01; Tranbaction Date(s): 2000-09-01, 2000-10-28, 2000-11-17, 2000-05-09;

 

I want to add a couple of words to end of it

 

is this possible maybe using a conditional statement if this colulmn has "" then add "comment etc etc" ?

I have 3 diff flags I need to input 

 

 

thanks

 

 

5 REPLIES 5
Christina_H
14 - Magnetar

I don't know what you're checking for to add the flags, but something like this:

IF Contains([Column],"Check1") THEN [Column]+"Flag1"

ELSEIF Contains([Column],"Check2") THEN [Column]+"Flag2"

ELSEIF ...

ELSE [Column]

ENDIF

Hi2023
8 - Asteroid

Wait maybe I said it wrong but I need to add a few words if a column has that certain thing---how do I add words inside my column named comment?

Christina_H
14 - Magnetar

What column are you checking for your condition?  I assumed it was the same one you were adding comments to, and I've just called them both [Column] in the above.  It will add your flag to the end of the existing text in the column, which I think is what you're trying to do?  [Column]+"Flag" will return the existing contents of the column plus your flag.

Hi2023
8 - Asteroid

No, if in the 'SamePOIAcctandTrl' columthen add the words "dup orig feed' to the end of the  "comment" column

Christina_H
14 - Magnetar

Is that a Boolean column?

 

IF [SamePOIAcctandTrl] THEN [comment]+" dup orig feed"

ELSE [comment]

ENDIF

 

You can add extra ELSEIF statements if you need them.

Labels
Top Solution Authors