Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Flipping a set of columns

Brawlstrogg
7 - 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?

2 REPLIES 2
vishwa_0308
11 - Bolide

Hi,

 

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

 

Pic3.jpg

 

 

Brawlstrogg
7 - 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