This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Instead of using the update value option in the action, use the "Enable/Disable Container from Question" option.
When using this option if you select CSV, you will want it to disable the XLS container (so the CSV check box action will need to be linked to the XLS container and the XLS check box action will need to be linked to the CSV container).
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.