Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Flipping a set of columns

Highlighted
Meteor

Hi folks,

 

Having some issue with the Transpose/Cross Tab tools and wondered if I could get some help?

 

I've got the following setup;

 

DateProductsWorkarea1Workarea2Workarea3Workarea4Business Area
01-12-17Recieved Today300100900...Site 1
01-12-17Done Today25025500..Site 1
01-12-17Done Today (Rej)2525102...Site 1
01-12-17OTS2550.....Site 1

 

That goes down around 7000 rows on an Excel sheet.

 

I need it to look like the following;

 

DateWork AreaRecieved TodayDone TodayDone Today (REJ)OTSBusiness Area
01-12-17WorkArea13002502525Site 1
01-12-17WorkArea2............ 
01-12-17WorkArea3     
01-12-17WorkArea4     
01-12-17WorkArea5     
01-12-17WorkArea6     
01-12-17WorkArea7     
01-12-17WorkArea8     
01-12-17WorkArea9     

 

I've been arguing with the Transpose/Cross Tab all morning but can't seem to crack it?

Highlighted
Alteryx Certified Partner

Hi,

 

Please go through the workflow, it will take you closer to get the result.

 

Pic3.jpg

 

 

Highlighted
Meteor

Hi @vishwa_0308 - We're getting there. On the cross-tab I'm running into an issue where the date becomes NULL and the data literally becomes a mash of all the different sets "0, 6, 12, 18, ..."

 

Any ideas?

 

STRIKE THAT

 

I've got Null dates floating around. Works perfectly mate. Thank you!

Labels