Difficulty in parsing column

[sriniprad08]

Hi Team,

Hope you are well. i have a column which has different categories.

if the numbers after the 'cxl' needs to be split into different columns. they have varying field. so the number of column has to be dynamically created to accomodate numbers.

Please let me know how to go about it?

thank

Sri

[martinding]

Hi @sriniprad08 ,

Please see attached:

[PhilipMannering · Accepted solution]

Here's a single tool solution,

[sriniprad08]

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

[martinding · Accepted solution]

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.)

[PhilipMannering]

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,

[sriniprad08]

Hi @PhilipMannering ,

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

[sriniprad08]

Hi @martinding 

thank you so much :). have a nice day. Appreciate your support and solution.

cheers,

Sri

[PhilipMannering]

Hi @sriniprad08, my mistake. You can replace the "+" with a "*" in the regex expression and it'll get that CNR number too.

[sriniprad08]

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?