hello,
I'm having trouble in regard to duplicating a column. Note: column names change from month to month and are added to an existing file with prior months data. The goal is to have a prior month column become a current month column, which I am able to dynamically select and achieve. The issue is I also need to keep that prior month column. Does anyone know how to achieve this?
Ex: tocarryover02 data will need to be in a new column labeled pmcarryover03. I am able to dynamically select/change the column name from tocarryover02 to pmcarryover03. However, how do I also keep the tocarryover02 column at the same time?
Please see attached for sample dataset.
Thank you,
Gianna
You could dynamically split this field from your dataset and join it back by Record Position.
Use a combo Dynamic Select + Join Tool. It could work well.
Cheers,
Please see below :
I added some comments on the workflow to explain what I have done.
Hope this helps,
Regards,