How to duplicate a column month over month

[gianna_albano]

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

[Thableaus]

Hi @gianna_albano 

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,

[messi007]

@gianna_albano,

Please see below : 

I added some comments on the workflow to explain what I have done.

Hope this helps,

Regards,