Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Transpose

martina21
5 - Atom

Hello! I have this data below and I want to edit the layout. Can I use transpose to do this?

 

 

Input

HoursMaker / CheckerProcess2/1/20212/2/20212/3/20212/4/2021
19MSign16212413
3MTemplate61153
3MInquiries82069
10MEmail0000
HoursMaker / CheckerProcess1/4/20211/5/20211/6/20211/7/2021
19MSign4131618
3MTemplate12341200
3MInquiries4803
10MEmail0000

 

Output - something like this

 

HoursMaker / CheckerProcessNameValue
10MEmail2/1/20210
10MEmail2/2/20210
10MEmail2/3/20210
10MEmail2/4/20210
10MEmail1/4/20210
10MEmail1/5/20210
10MEmail1/6/20210
10MEmail1/7/20210
3MInquiries2/1/20218
3MInquiries2/2/202120
3MInquiries2/3/20216
3MInquiries2/4/20219
3MInquiries1/4/20214
3MInquiries1/5/20218
3MInquiries1/6/20210
3MInquiries1/7/20213
19MSign2/1/202116
19MSign2/2/202121
19MSign2/3/202124
19MSign2/4/202113
19MSign1/4/20214
19MSign1/5/202113
19MSign1/6/202116
19MSign1/7/202118
3MTemplate2/1/202161
3MTemplate2/2/20211
3MTemplate2/3/20215
3MTemplate2/4/20213
3MTemplate1/4/2021123
3MTemplate1/5/202141
3MTemplate1/6/202120
3MTemplate1/7/20210

 

Thank you 🙂 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@martina21 

I think a Batch Macro should do it.

0328-martina21.PNG0328-martina21-1.PNG

apathetichell
19 - Altair

I think the problem is that you have two sets of dates... Ideally you'd have one set of dates across the top and empty fields where no information exists - then a simple transpose with key columns of Hours, Maker/Checker, and Process would give you what you want (and you can filter out the blank entries.).

 

With data like this - what I'd do is still transpose with those three key columns then transfer over to the name column where the values are the new dates. Then use a multi-row to change out the old dates and finally a filter to take out the row with dates in the value fields...

 

I've attached a workflow that shows how to do that.

Labels
Top Solution Authors