Hi ,
I want to have expand / collapse button in final output of Alteryx like we have in excel?
Is it possible to do it in Alteryx? If yes can you please let me know how to do that?
Thanks in advance
Hello @Sumit_Anand
Alteryx can help you preserve the format of an Excel Output so you can keep your grouping, conditional formatting,..etc
This option will need that you specify the range of your data. Please see below
This is a formatted template that shows headers in bold as well as some grouping.
We have different data and we'll use Alteryx to overwrite the values in a specified range while checking "Preserve Formatting on Override"
Looking at the same file (template), you will see that values were replaced to show T (for test) after every entry - which is the data coming from the text input that replaced original values. You'll notice that headers are still bold and groups are still there
Hope that helps. Cheers!
