Hi Team,
Is there any pre set command in Alteryx like VBA code to format the Output data if not then how to write the code in Alteryx .
Hi @ShreyaSharma,
For my best knowledge no.
This is a post that has an example of using vba with Alteryx.
Hi @Emil_Kos
One question I have ...
My output excel file size is 40 MB ... containing 7 tabs .
Now, I implemented the reporting functionality to get the output in more presentable format but the disadvantage i could see is it take too much time to get the output. Also the file size turn to 300 MB .
Is there a way to reduce the size of the output file using when we use the reporting tool like render to get the output in more format manner.
Thanks for your help
Hi, please check out the link below:
@ShreyaSharma
I made this sample before for alling VBA in alteryx.
It should give a start on how to to use it.
Hi Qiu, Attachment is corrupt. Can you please reload it?
@Subh
I took it out of a bigger flow, and I think they are some dependencies there.
Just ignore the pop up error and I just tested.
@Qiu - I have modified the codes and input source for Essbase retrieval (aslo added as Boolean in VB) but did not work out.