Parsing multiple fields (with different patterns)

vplante

Hello,

I am trying to figure out the following issue

Input data:

Name	Format	System	Identifier 1	Identifier 2
Phone number	FLOAT	System A System B System B	PHONE 44_PHONE 55_PHONE	NUMBER 44_NUMBER 55_NUMBER
Address	VARCHAR VARCHAR2	System A	ADDRESS FULL_ADDRESS	STREET STREET_NAME

Desired output:

Name	Format	System	Identifier 1	Identifier 2
Phone number	FLOAT	System A	PHONE	NUMBER
Phone number	FLOAT	System B	44_PHONE	44_NUMBER
Phone number	FLOAT	System B	55_PHONE	55_NUMBER
Address	VARCHAR	System A	ADDRESS	STREET
Address	VARCHAR2	System A	FULL_ADDRESS	STREET_NAME

Note the following patterns:

- Name is unique to an attribute

- Format / System / Identifier 1 / Identifier 2 can vary but should be mapped with the corresponding value on the same line (ex: System A / PHONE / NUMBER)

- If there is only one value for format or system, it means that it will remain the same for all the identifers.

Thank you so much

wdavis

Hi @vplante 

Okay, the best way to be able to parse multiple fields at the same time would be to use a Transpose to get all of your values into one column, you can then add any necessary steps you require, before reformatting the information using a Cross-Tab. The workflow has now been updated to include these steps.

Parse Patterns.yxmd