Output Table Query

[clarrock]

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 :

Test

Team-3(DGF:1234

ABC:546)

Team4(DGF:789)

Group-88(GH-6897)

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

Test	1	2
Team-3(DGF:1234 ABC:546)	Team-3	DGF-1234 ABC:546
Team4(DGF:789)	Team4	DGF:789
Group-88(GH-6897)	Group-88	GH-6897

[DawnDuong]

Hi @clarrock 

one way is to your Regex tool to Parse data

(.*)\((.*)\)

dawn 

[cgoodman3]

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)