Pivot in Ateryx

Question

I have build a recon in alteryx, which gets formated via basic table and saved via render tool. However I want to know is there a way wherein Ateryx can create excel like pivot in separate tab in same output file which can be refreshed out of alteryx as we do some manual changes to recon later.

putu_w_erata · Answer

I am going to assume you are talking about Excel Pivot Table, Alteryx Summarize Tools is basically this. I attached a sample workflow for you to use if you want to write the same excel file with multiple tabs (1 for the table details and the other for the pivots)

Excel Pivot multitab.yxmd

Qiu · Answer

@sirsjat21

Without any sample data, it is hard to say anything, but there is a Pivot feature in the Table tool as blow.
maybe it will help.

Raj · Answer

Will you be able to share some sample to Make this more clear

anything in form of image or any sample.