Alteryx Designer Desktop Discussions

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

If item a doesnt have O, add O

terrellchong
8 - Asteroid

Hi,

 

I have a set of table that looks like this:

 

FileNameRef
AA
AC
AH
AN
AT
AUA
AUB
MC
MH
MN
MT
MUA
MUB
MO

 

And I want to check if let sat FileName "A" doesnt have Ref "O", add in "O"

 

My expected output as below

FileNameRef
AA
AC
AH
AN
AT
AUA
AUB
AO
MC
MH
MN
MT
MUA
MUB
MO

 

How should I go from here?

1 REPLY 1
ncrlelia
11 - Bolide

Hi @terrellchong ,

 

  1. You can first create a table (say Table A) containing a unique list of FileName and have a Ref column = O for each FileName.
  2. Then join Table A to your original dataset, those records in Table A that are not map to your dataset are those FileName that do not have Ref 'O'.
  3. You can then add these unmatched records to your original dataset.

ncrlelia_0-1659490542548.png

 

Attached workflow for your reference. Hope it helps.

Thank you.

 

Best Regards,

Lelia

Labels