Help in Transforming Data

[Wole_09]

Hi all,

I am an alteryx enthusiast but I aspire to improve on it with time. 

I am currently working on transforming a file(attached herewith). Could someone provide a better workflow for transforming it to the desired format in the attached file?

Thanks in advance.

[Qiu · Accepted solution]

@Wole_09 
Try to make it dynamic.

[Wole_09]

Hi Qui,

Thanks alot for the solution.

It really works. Yea, I understand I could have been more dynamic, but I also don't want to expose confidential information.

I was able to complete the remaining tasks by building on your workflow.

Thanks.

[Qiu]

@Wole_09 
Glad to help and thank you for the accept mark.🤝

[Wole_09]

Hi Qui, 

How are you? 

Could you help me with solving this issue?

I want to replace the values in the current format with the values in the desired formats.

Because it is a recurrent monthly task, the values in the current format will always be replaced with the values in the desired format every month.

I have tried the switch current field in the multifield tool, but it is not working perfectly. Can you please help me?