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