Row duplication and text editing

Hi!

I am pretty new to Alteryx and am trying to create a payroll reconciliation.

I have figured out what to do with my data from the GL, but the pay register data is a bit different. The pay register data has a column for ledger account number. When more than one ledger account is hit, they are shown in the same cell. (i.e:

10000:Payroll Withholdings Clearing60000:Benefits)

First of all, I need to duplicate the rows where these occurrences happen and I need to make sure that the ledger account column has one of the rows to just have 10000:Payroll Withholdings Clearing in the ledger account and the other to just have 60000:Benefits.

For visual aid, this is what I'm starting with:

Amount	Ledger Account
100	10000:Payroll Withholdings Clearing6000:Benefits

And this is what I want:

Amount	Ledger Account
100	10000:Payroll Withholdings Clearing
100	60000:Benefits

Please let me know if you have any solutions!

Thanks!

Transformation

Preparation

Accepted answers

Hi @tracyjclark ,

I have created an example using regex and identifying patterns to achieve what you need.

Take a look at the attached example and let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-16 Row duplication and text editing.yxmd

All comments

Hi @tracyjclark ,

I have created an example using regex and identifying patterns to achieve what you need.

Take a look at the attached example and let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-16 Row duplication and text editing.yxmd

Quick Links

Tags

This months top contributors

Hollingsworth 335