Hi all, I am new to Alteryx and I am trying to combine values across different columns. (See below). I am not sure where to start. Input Access_ControlR01#R02ACCT_OPSR01ACQR01#R02#R03 Output Access_ControlAccess_Control.R01#Access_Control.R02ACCT_OPSACCT_OPS.R01ACQACQ.R01#ACQ.R02#ACQ.R03 Thank you in advance for your assistance.

Combine values across different columns

Hi all,

I am new to Alteryx and I am trying to combine values across different columns. (See below). I am not sure where to start.

Input

Output

Access_Control	Access_Control.R01#Access_Control.R02
ACCT_OPS	ACCT_OPS.R01
ACQ	ACQ.R01#ACQ.R02#ACQ.R03

Thank you in advance for your assistance.

Hi @tww ,

There are multiple ways to achieve the desired output.

Please find attached:

Hi @tww ,

There are multiple ways to achieve the desired output.

Please find attached:

One way of doing this.

Steps

1. Text To Columns : split by rows

2. Formula : concatenate the two strings

3. Summarize : combine the strings with Group by Col1.

Formula

Output

I hope this might help.