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.
Solved! Go to Solution.
Hey @vepp,
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).
Let me know if this works for you.
You can connect an action tool directly to a container to enable/disable based on a True/False condition. I am thinking maybe you could use these to enable or disable based on what is being fed in?
Edit: @cplewis90 beat me to it 🙂
@BrandonB @cplewis90 Thanks for the response. But I am getting below error. Looks like container is not disabled completely when I have some interface tools inside it. Is this expected?
Tool Container (2) Disabled containers may not contain interface tools.
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.