community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Change Date from Row to Column dynamically. Input file displayed below

irfanchoudhry
5 - Atom
‎05-29-2024 07:44 AM

data file is attached with expected output format

  MetricsTuesday, May 28, 2024Wednesday, May 29, 2024Thursday, May 30, 2024
Work streamProducts/ServicesNameDescriptionFrequency6:00:00 AM9:00:00 AM12:00:00 PM3:00:00 PM6:00:00 PM9:00:00 PM12:00:00 AM3:00:00 AM6:00:00 AM9:00:00 AM12:00:00 PM3:00:00 PM6:00:00 PM9:00:00 PM12:00:00 AM3:00:00 AM6:00:00 AM9:00:00 AM12:00:00 PM3:00:00 PM6:00:00 PM9:00:00 PM
Sales statusSales statusGroceryNumber of ItemsDaily    252525   2525252525   2525252525
FurnitureStylesDaily    252525   2525252525   2525252525
Home AppliancesImported and ExportDaily    252525   2525252525   2525252525
Preview file
28 KB
Labels:
Reply
0 Likes
2 REPLIES 2
terry10
12 - Quasar
‎05-29-2024 10:12 AM

@irfanchoudhry 

 

I suggest cleaning up your excel file first, especially unmerging cells, before inputting into Alteryx. Otherwise your results may not be repeatable.

Reply
0 Likes
aatalai
14 - Magnetar
‎05-29-2024 10:57 AM

@irfanchoudhry does this post not solve your ask https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/there-is-date-field-in-a-row-b...

 

?

Reply
0 Likes
industry user group interest form
Labels
Top Solution Authors
View All