community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

How to rearrange a table?

Highlighted
Meteoroid

Hi community,

 

I have a table with this structure:

DateShopQty_Prod_AQty_Prod_BQty_Prod_C
Sep 2016W291185
Sep 2016X772156
Sep 2016Y584327
Sep 2016Z864027
Oct 2016W549971
Oct 2016X229932
Oct 2016Y352137
Oct 2016Z893144

 

How can I change the structure to get the follwoing table: 

ShopProd_TypeSep 2016Oct 2016
WA2954
WB1199
WC8571
XA7722
XB2199
XC5632
YA5835

 

Thanks

I suggest the following:

 

2017-11-25_12-44-00.jpg

 

1. Transpose the Qty columns

2. Parse the Date to yyyyMMdd and create the Prod type

3. Cross tab to get to the required layout

4. Dynamic rename to label the columns correctly

 

Sample attached

 

Labels