I have a table like NameIDJohnjn12jimjm13jackjk14 I want to add two new rows only if the ID column contains "jk14". The two new rows would be something like NameIDjackson jackie Final output if ID column contains "jk14" should be: NameIDJohnjn12jimjm13jackjk14jackson jackie Final output if ID column Doesnt contain "jk14" should be: NameIDJohnjn12jimjm13

Add or remove rows based on a condition

I have a table like

Name	ID
John	jn12
jim	jm13
jack	jk14

I want to add two new rows only if the ID column contains "jk14".

The two new rows would be something like

Name	ID
jackson
jackie

Final output if ID column contains "jk14" should be:

Name	ID
John	jn12
jim	jm13
jack	jk14
jackson
jackie

Final output if ID column Doesnt contain "jk14" should be:

Name	ID
John	jn12
jim	jm13

Preparation

Data Investigation

Accepted answers

Christina_H

I've used a random sample tool to randomly take two of your input rows. If jk14 is included, the extra two rows will be added.

Extra rows.yxmd

All comments

Christina_H

I've used a random sample tool to randomly take two of your input rows. If jk14 is included, the extra two rows will be added.

Extra rows.yxmd

JamesCharnley

Hi @Santhoshraj

If you're using 2023.1 then a workflow with a contains check and control containers should work nicely (I'm kind of just playing around with control containers where possible at the moment). The workflow is sort of a mess but looks like this:

It's using a summarize tool to concatenate IDs to check the presence of jk14 in any row in a filter. If there is an instance of jk14, the above control container is activated, adding the extra rows on. If there is no instance of jk14, the below control container is activated, but the two streams can be joined together. Without the control containers, the extra rows would still be unioned after the first control container so different logic would be needed.

ControlContainJK14.yxmd

Santhoshraj

@Christina_HGreat. Thanks a lot. It worked for me.

Santhoshraj

@JamesCharnley Unfortunately I am using an older version of alteryx and couldnt try out your solution. Thanks for the help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703