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

Transpose, Crosstab and Append Multiple Individual Files

TomMishima
6 - Meteoroid

Hi,

 

I have multiple files in the format:

 

1.png
When I use the transpose and cross tab tools on a single file I achieve what I need, ie:

 

 3.png

However when I use multiple input via the wildcard I get the following:

 

2.png
I need to append the output after the crosstab to all of the input files since each report contains about 20 fields of data all individual to that report. 

 

Thanks!

11 REPLIES 11
JordanB
Alteryx
Alteryx

Hi @TomMishima

 

No problem at all! 

 

For more information on the different ways to bring in data check out this article by @AlexKo and Myself.

 

Have a good rest of the day.

 

Best,

 

Jordan

TomMishima
6 - Meteoroid

Thanks @JordanB, that's really useful, definitely bookmarking it!

Labels