Required data in different format

[Maheshp]

Hi Team,

I am preparing the workflow but facing some issue, as I have attached the two files where in first attachment, I have the data available, but I want the data in "required data" format. could you please help us to guide. what option need to pick.

Regards,

Mahesh

[OTrieger]

@Maheshp 
It is not as difficult as it may seems to be from first glance. My suggestion is to pull the data into Alteryx and then look what do you see in the Results Window.
The minute that you will figure out how to relate the currency to the values you will figure it out what to do

[Maheshp]

Thanks for the suggestion, but it is not working.

[Qiu · Accepted solution]

@Maheshp 
Structuring non-structure data is really depending on the format.
Assuming the data will not change, this is my approach and I was trying to be as dynamic as possible.

[OTrieger]

As I said, first figure out which data is needed and with which tools you can get it. There are no macros or advanced tools here.
It is all about understanding which data is needed and how to get it.

[Gumsmenezes]

There you go buddy, I tried making as dynamic as possible. When it comes to the currency/months you won't have to worry in the future (if new currencies or months are added). There's only 1 comment I made, to double check the FY (as of now it captures the year in which you run the workflow). Let me know what you think :)

[OTrieger]

What have you done so far to solve this issue, which steps you tried?

[Maheshp]

Thanks, this is helpful :)