Create a Pivot in Alteryx

Hi Community,

I've an extract of our planning engine, and I have to create pivots based on Item / Order type to workout what we can move to other Lines / Sites, but I can't get the pivot data to work for me in Designer, so looking for some help pls.

Getting this error in WF,everything up to the Pivot creation is running perfect, creating separate tab data in Exceel WB like I want it to, just can't get pivot data view.

Sample of the pivot Data we extract from Excel, we also do a If Statement in the last column to say if we have no stock don't include it as excess.

Sample Pivot Data.xlsx

Workflow

Accepted answers

Emil_Kos

Hi @Karl_Spratt,

In the select tool before the cross tab you don't have a column with ITEM_QTY as a name:

I don't know the process but it looks like you want to use this column in your cross tab:

You need to change a column header function to a column that you want to have in the header. Like in exemple below:

This is helpful for you?

All comments

Christine_Assaad

Hi @Karl_Spratt

The Item_Qty that you have as header in the Crosstab is not included in your data set. Perhaps you changed its name to Item?

If you are able to share the workflow.. this will be helpful. Cheers!

Qiu

@Karl_Spratt
Agree with @christine_assaad , Can you give us a bit more info?

At least the "Order Type" Field is missing from your sample Excel File.

By any chance, the Field "Item_Qty" is deselected the Select Tool prior to the Cross Tab tool and causing the error?

grazitti_sapna

Hi @Karl_Spratt , for some reason I believe this field looks missing before the cross tab tool kindly check the join and select tool if this particular field is deselected or as suggested kindly check if you have renamed this field and then try running the workflow again.

I hope this helps.

Thanks.

Karl_Spratt

Hi Guys,

WF not creating the last step the pivot views, attached the CSV input file we run the WF on, ( I have changed some of it to "sample data" but columns, are the same. We take the WF output, load it into this Excel T/plate and refresh the pivots manually. looking to try have Alteryx create the complete package.

Attached is the CSV input file, the t/plate and the Alteryx WF, if anyone could explain / show to me how I can create the pivots I'd be really thankful.

TIA Karl

Sample Excess Inventory Analysys - 20.12.04.xlsx

UCV-ASCP-Excess.yxmd

xxascp_supply_demand_extract_report_20201204.csv

Karl_Spratt

Hi Qiu,

Did you see my reply to the thread, with the additional sample data. Can you take a look and advise if thes pivots can be replicated using Alteryx WF logic please.

TIA

Karl.

Emil_Kos

Hi @Karl_Spratt,

In the select tool before the cross tab you don't have a column with ITEM_QTY as a name:

I don't know the process but it looks like you want to use this column in your cross tab:

You need to change a column header function to a column that you want to have in the header. Like in exemple below:

This is helpful for you?

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262