Pivot Using Blob

Question

Hi All,

I am working to create  PIVOT table using Blob in Alteryx. The input data from Rejections tab should be used to create the PIVOT table in PIVOT Rejections sheet. The blob is not creating the PIVOT in a different sheet.

I have attached the Template and Sample Output (Rejects Output) along with the workflow I am getting error.

Template.xlsx

Rejects Output.xlsx

PIVOT with Blob.yxzp

OTrieger · Accepted Answer

@PatelN

A Pivot is an Object in excel, if you will try to write data to it in excel you will not manage to do it, same with Alteryx, to change a Pivot table you will need to change the data source and refresh it.

What you can do with Alteryx is override the source data for the pivot and then the person that will use it will need to refresh the pivot to reflect the next data.

PatelN · Accepted Answer

ok, got it. Thanks for the help and reply.