Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Alteryx Designer put headers in different places

krmplt
6 - Meteoroid

Hello everyone,

 

I have an excel input that comes in the following format:

DateWork ReceivedWord Done
01/11/20193330
02/11/20192725
03/11/20193232
04/11/20191211
05/11/20198583

 

However, I need to make a report with this data in this format:

 

 01/11/201902/11/201903/11/201904/11/201905/11/2019
Work Received3327321285
Word Done3025321183

 

I have tried to use the transpose tool, but I'm not able to get the expected result, does anyone have any suggestion on how to achieve this?

 

5 REPLIES 5
benakesh
12 - Quasar

Hi @krmplt ,

You may need more than one transpose/cross tab tools .

benakesh_0-1573222101543.png

 

 

 

krmplt
6 - Meteoroid

Hi benakesh,

 

Thank you very much for your help.

However, when I open the workflow you attached I only see this:

tc21.PNG

Have you got any idea, of what's going on?

 
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi,

 

This should achieve the changes you're looking for:

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

krmplt
6 - Meteoroid

Hi @Jonathan-Sherman

 

Worked like a charm!

Thank you very much

benakesh
12 - Quasar

Hi @krmplt ,

Sorry , edited my original reply and attached correct wf.

Labels