Create List out of Column values

Hi Team,

I am fetching data based on a sql code that has condition Segment in ('ABC','DEF','GHI'). So, with interface, I want to have all values of segment column in the form of List. So that I can simply select multiple values from that list and will receive data only for those selected(multiple) segments on executing WF

Since my table(on which I ran query) contains large set of data so I want to apply that filter of segment on the sql code itself. Purpose is, that way performance will faster and we will be able to exclude unwanted data at the very starting of the WF.

It will be great if you share sample WF for the same.

Tips and Tricks

Apps

Interface Tools

Accepted answers

All comments

Robin_McIntosh

Try this. You'll obvisouly need to update the database connections (i.e. YourDSN, YourSchema, YourTable, etc.)

Dynamic_Column_Values.yxwz

Vikas038

Hi Robin,

I tried given WF and updated database connections but list is not populating any of the unique values available in mentioned column. So list is coming up blank. I tried couple of changes like enabling browse via interface designer but still list is coming blank. Can you suggest on this?

Vikas038

Hi Robin,

It wont be feasible to upload my WF. Although, I am using Oracle to query my data and using your by just changing database connections

Robin_McIntosh

@Vikas038 There are some differences in SQL between DB2 and Oracle. For instance, DB2's CURRENT DATE translates to Oracle's SYSDATE. You will need to make sure the entire SQL is translated.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703