Split columnA based on certain values in columnB

[N598011]

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 solution]

 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 solution]

It worked!  thank you!