Transpose some columns as rows

[felipe_caru]

Hello all, I'm new at Alteryx and thus, not know much on how to use it.

I am trying to transpose some data from columns to row, but what I've found in the description of the tool 'transpose' doesn't seem to work for what I want. Can anybody help me / guide me with this?

What I want to do is the following. The data from Table 1/Origin is, as example:

NAME	01/01/2019	02/01/2019
A	1	2
B	3	4
C	5	6
D	7	8

And I want to end with the data like this:

NAME	DATE	DATA
A	01/01/2019	1
B	01/01/2019	3
C	01/01/2019	5
D	01/01/2019	7
A	02/01/2019	2
B	02/01/2019	4
C	02/01/2019	6
D	02/01/2019	8

How can I do this? Is it possible?

[Thableaus · Accepted solution]

Hi @felipe_caru 

Did you select "Name" as a key field?

Cheers,

[Thableaus · Accepted solution]

@felipe_caru 

Sorting by date you get your final result:

Cheers,

[echuong · Accepted solution]

See attached for an example workflow. Let me know if that works for you!

[felipe_caru]

@Thableaus

Thank you, did the test with some data and it worked as seen. Question, though:

I am using an Excel sheet as the input data. If I update the Excel sheet with more inforamation, is there any way to refresh the input? Because most likely I'll be chaning the information on it (such as the number of date columns, since some months can have 30, 31 or 28 days for example).

I am asking because I tested it by adding more columns, however when running the workflow again it only shows what I had before, in the first Excel file.

[Thableaus · Accepted solution]

@felipe_caru 

Yes, you need to check the "Dynamic or Unknown Fields" option of the Transpose tool, under the 'Data Fields'.

That way in case of new columns come up in your file they will be automatically selected and transposed.

Cheers, 

[felipe_caru]

Thank you very much!

I realized that my data didn't update because I had input as text file, and not a file itself. When I used it as input file (not text), it worked. Thanks again