Output Table Query

Question

Hi Alteryx Team,

How do I add my current column data to the previous column, if the current column has the first 3 letters words to left as ABC. If the current column doesn't have the words ABC it remains the same.

Eg: my input :

TestTeam-3(DGF:1234ABC:546)Team4(DGF:789) Group-88(GH-6897)

My Output : I also want to split that which in brackets to be separate  column.

Test12Team-3(DGF:1234 ABC:546)Team-3DGF-1234 ABC:546Team4(DGF:789)Team4DGF:789Group-88(GH-6897)Group-88GH-6897

cgoodman · Answer

Based on the example data it looks like you want to do a few things.

1) you want to concatenate values where the line does not contain an opening bracket. I would do this with a multirow formula where you create a new column called ID and have

IF Contains([Test], '(') THEN [Row-1:ID] + 1 ELSE [Row-1:ID] ENDIF

This will get you something you can group on in a summarise tool, and you can then concat [Test]

2) You can then split your data on ( as a delimiter and then remove the extra ) with a formula tool.

(I’m not on my laptop so the formula above is from memory)

DawnDuong · Answer

Hi @clarrock

one way is to your Regex tool to Parse data

(.*)$(.*)$

dawn