Split columnA based on certain values in columnB

Question

Hi,

I joined Alteryx last week and find it quiet useful!

I have 2 columns (A and B)  and I want to split the values in columnA only if columnB has a specific value.

example:

row 1: ColumnA = PETER BARRY DELANEY; ColumnB = IND

row 2: ColumnA = Myclient Canada LP; ColumnB = NIND

I only want to split ColumnA into 3 new column when ColumnB has IND flag, else keep column A as is

thanks!

cjaneczko · Accepted Answer

You could use a filter on Column B where it = IND, then use the split to columns on the T side of the filter. Put a union after that to bring the T side and the F side back together.

N598011 · Accepted Answer

It worked!  thank you!