How to duplicate a column month over month

Question

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

Example.xlsx

messi007 · Answer

@gianna_albano,

Please see below :

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

Hope this helps,

Regards,

NewColumn.yxmd

Thableaus · Answer

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,