Read multiple file types with same macro using checkbox

Question

All,

I would like to have single macro to read all xls and csv formats. Both file type needs different type of settings due to their difference hence I have  created 2 containers. My expectation here is

to enable xls or csv based on a check box or radio button as per the need but the macro is throwing error if I don't provide input  to any one of them. The macro is expecting me to give values for both csv and xls even though the container is in disabled state.

In short, If I select CSV it should expect values only for csv and execute csv read. If  XLS is selected then it should run the XLS container without worrying about  input and output of CSV container. Attached the same workflow, please try and let me know your thoughts and idea.

NOTE : I have separate macros for CSV and XLS  reader which is working fine. This ask is to merge as a single macro.

Test_Different_Macros.yxzp

cplewis90 · Accepted Answer

Hey @vepp,

Just put all interface tools outside the containers. You should be able to nest interface tools in the UI within others within the interface designer so when they are selected they will expand and show other options. Let me know if you have questions on this and I can send some screenshots.

vepp · Accepted Answer

For others benefit. Attached macro will read from all type of Excels and CSV with multiple options

vepp · Accepted Answer

Someone tested the attached reported that it has missing macro!. Please use this attached missing macro. This should resolve the issue. For some reason Alteryx didn't package it with all macros.