How to identify Columns which are not selected in "SELECT" Tool

Hello,

I have created a user interface , where the user can select certain columns using LIST BOX. These selections are then passed on to the SELECT tool using ACTION tool , and then they move on for further processing. This works fine.

My doubt is, how do I now access the columns which were not selected in the LIST BOX.

Basically I need two branches, one with the columns I selected and one with columns which were not selected.

Let me know if someone can guide me on the same.

Thanks

Antony.

Common Use Cases

Accepted answers

jdunkerley79

Not sure if there is a simpler way but if you use action tools to rewrite XML of select directly can achieve what you want.

The attached macro takes an input and output the selected and other columns.

SelectWithOthers.yxmc

All comments

jdunkerley79

Not sure if there is a simpler way but if you use action tools to rewrite XML of select directly can achieve what you want.

The attached macro takes an input and output the selected and other columns.

SelectWithOthers.yxmc

ardsilva

Thank you, this was new to me

Can I use this same approach(editing raw xml) , if I want to connect ACTION button to a MACRO instead of SELECT tool (So LISTBOX ->ACTION ->MACRO) ? . How do I go about editing the XML ? Do you know if any documentation is available for this ?

Should my approach be :

1. Create the workflow

2. Open the workflow in text editor and understand the xml block I need to change

3. Write the formula to replace the xml

Basically my Macro needs to know what I have selected and not selected in the LISTBOX. So am assuming I just need to toggle the True/False flag.

Thanks

Antony.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703