Copying String from multiple columns to one column

[jenettd]

Hi Alteryx Community,

How would I filter out Fail messages from multiple columns and copy them to another column? The Fail messages can be anywhere in the field and they have a comma delimiter. 

Example - I'd like to copy and compile Fail messages from columns B to E into column A. The messages are separated by a comma and I'd like for them to be comma delimited once copied to column A as well. 

Thanks for your help!

A	B	C	D	E
	Fail - Blank or Null,Pass - No PDE Present,UCEN Fail - Not in ADMF	Fail - Blank or Null	Pass - Present in ADMF	BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL
	Fail - Exceeds 1024 characters,Pass - No PDE Present,UCEN Fail - Not in ADMF	Fail - Blank or Null	Pass - Present in ADMF	BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL
	Pass - No PDE Present,QA Fail - Leading Space,UCEN Fail - Not in ADMF	Fail - Blank or Null	Pass - Present in ADMF	BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL
	Pass - No PDE Present,QA Fail - Trailing Space,UCEN Fail - Not in ADMF	Fail - Blank or Null	Pass - Present in ADMF	BL Fail - BL repeats dif BDE,Pass - Same BDE, Same BL

[davidskaife · Accepted solution]

Hi @jenettd 

It's not elegant but the attached should work - assuming the number of delimiters remain the same in all columns etc

[jenettd]

Thank you!