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
Gelöst! Gehe zu Lösung.
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 @martinding
thank you so much :). have a nice day. Appreciate your support and solution.
cheers,
Sri
Hi @sriniprad08, my mistake. You can replace the "+" with a "*" in the regex expression and it'll get that CNR number too.
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?