If item a doesnt have O, add O

[terrellchong]

Hi,

I have a set of table that looks like this:

FileName	Ref
A	A
A	C
A	H
A	N
A	T
A	UA
A	UB
M	C
M	H
M	N
M	T
M	UA
M	UB
M	O

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

My expected output as below

FileName	Ref
A	A
A	C
A	H
A	N
A	T
A	UA
A	UB
A	O
M	C
M	H
M	N
M	T
M	UA
M	UB
M	O

How should I go from here?

[ncrlelia · Accepted solution]

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.

Attached workflow for your reference. Hope it helps.

Thank you.

Best Regards,

Lelia