Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose

deepakshaw1991
7 - Meteor

Input looks like:-

deepakshaw1991_0-1631214495302.png

Please note that all the figures and headings can change, also the number of columns can increase or decrease.

 

Required Output:-

deepakshaw1991_1-1631214542723.png

 

5 REPLIES 5
Luke_C
17 - Castor
17 - Castor

Hi @deepakshaw1991 

 

Here's an example of how you can get this to work: 

 

  1. Isolate the multiple header rows (first 3 rows) and transpose/crosstab to get a table of Entity ID, Entity Name, and Currency
  2. Read in the rest of the data and use the dynamic rename to promote the entity IDs to the headers, then transpose
  3. Join up the data from the first two steps on the entity IDs, and rename the fields.

This should get you going in the right direction, but let me know if you have any issues.

Luke_C_0-1631216967756.png

 

 

deepakshaw1991
7 - Meteor

Hi @Luke_C 

 

I am really very sorry for the late response. 

 

The solution shared by you is amazing and this is complete in nature. I am really very thankful to you for the help.

 

Have a great day ahead!!

 

Thanks & Regards,

Deepak

Luke_C
17 - Castor
17 - Castor

Happy to help! Please be sure to mark the solution on my reply so others can find it easier.

deepakshaw1991
7 - Meteor

HI @Luke_C 

 

I am facing another issue relating to alteryx.

 

Actually when I am using render tool to generate a report then the excel file generated contains data in number format. Can we convert it to string value.

 

deepakshaw1991_0-1633461386825.png

 

Thanks in advance.

 

Luke_C
17 - Castor
17 - Castor

Hi @deepakshaw1991 

 

What is the data type in Alteryx? If it's numeric try using a select tool to convert it to a string. Otherwise it may be excel trying to be smart and default it to be numeric.

 

As a side note, please be sure to accept the earlier solution :).

Labels
Top Solution Authors