Unpivot / Transpose

[KaterinaSimerdova]

Hello,

I have a folder loaded to Alteryx, updated every month with a new excel.

To format the data I use Transpose to unpivot to structure the days to a column instead of rows.

This works fine only for the first excel.

Problem is that only dates from the first excel appear in the result..

Could you please help?

Thank you.

[alexnajm]

Not sure what the issue is - in the Transpose you have "Dynamic or Unkown columns" as an option which will automatically bring in columns in the future which may not be known now

[emily852paul]

Like your workflow only reads columns from the first Excel file. Use the Directory tool + Dynamic Input so Alteryx reads all files properly, then transpose dynamically so it captures all dates. Want help setting that up?

[KaterinaSimerdova]

Hello @emily852paul , it seems that I don't have the Dynamic Tool in my Alteryx version...?

[KaterinaSimerdova]

@emily852paul it would be awesome, if you could help me setting this up..! How could we arrange that? Thank you very much!!

[alexnajm · Accepted solution]

@KaterinaSimerdova / @emily852paul the Directory tool

is not available in Designer Cloud. But the Transpose has Dynamic or Unknown columns available as an option so when new columns are introduced, they are automatically selected.