Difficulty in parsing column

Here's a single tool solution,

Parsing Columns.yxmd

Hi @sriniprad08

You could use the Join Tool and join on Record ID, please see below.

And to rename the columns, you can of course use the Dynamic Rename tool and name using formula:

"cxl" + current field name (deselect the record id and input fields first, but keep the dynamic fields checked.)

Hi @sriniprad08,

I've made a simple change to the Regex, under one assumption: that the dates following the contract are always in the form of dd.mm.yyyy, rather than ddmmyyyy.

Example - Parsing.yxmd

All comments

Hi @sriniprad08 ,

Please see attached:

Example - Parsing.yxzp

Here's a single tool solution,

Parsing Columns.yxmd

Hi @martinding ,

This is great. thank you. One question please how can i map the output with the input. I need the Input column as part of the output. Currently there is only RecordId

Thanks,

Sri

Hi @sriniprad08

You could use the Join Tool and join on Record ID, please see below.

And to rename the columns, you can of course use the Dynamic Rename tool and name using formula:

"cxl" + current field name (deselect the record id and input fields first, but keep the dynamic fields checked.)

Neatest solution is to use the Formula Tool to duplicate that column first. Just set the formula to equal the [Input] field.

Another option is to join the input and select "Join by Record Position" - no RecordID Tool required,

Hi @PhilipMannering ,

Great thanks. Any reason the marked in black is not coming please?

Hi @martinding ,

Thank you for all the great help. Can i request one more thing please. The attached workbook has different format. how can i go about this please?

to_ask_alteryx_p.xlsx

Sure @sriniprad08. Please see attached,

Parsing Columns.yxzp

Hi @martinding ,

The previous workflow is not picking the below example where its separated by comma, can you please help?

thanks

The first one. See the attachment in my previous comment.