To create an interactive table like we use pivot table on excel

[KeerthanaPriya]

Hi Team,

I created an output which gives in the pivot table fashion using Alteryx workflow. However, is it possible to create an interactive table which points to the detailed data using any of the Alteryx tools??

Thanks.

[aatalai]

@KeerthanaPriya not something I have explored extensively, but have you tried the pivot function  in the table tool?

If that fails, I would suggest possibly outputti ng teh raw data inother tab, not sure how palletable that would be though.

[KGT]

You would need to create an HTML output or similar to have it be Interactive. You could do it with a Python/R tool I'm sure.

It wont be simple, but if you want to play with it, then pick a Data Investigation or Predictive tool with an interactive output that is similar (It will be the I output), and right-click > Open Macro.

You will then see some of the R code that generates it and you will be able to copy that out to your own macro. Again though, it will not be simple (unless you really understand it).

[Gaurav_Dhama_]

I can vouch for that. I had extracted a piece of code from those tools to generate reports for one of my projects, it does work but can be confusing if you don't know R language. But it will be fine too if you do not have R understanding, but you understand any of the other programming languages.

[KeerthanaPriya]

Hey, I tried this unfortunately the pivot table option is disabled for my data set. Thanks.

[KeerthanaPriya]

Hey, thanks, I will try checking this.