Adding expand/collapse button in Alteryx .

[Sumit_Anand]

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

[christine_assaad]

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!