We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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