Need to populate two attributes from sql lookup

[rcclark]

Hello,

We have a need to populate two attributes in a table from two attributes in another table. I see how we can use the "SQL Query" or "Table or View" generators to populate a single attribute, but we have a need to populate two. Here is an example:

We have a codes table that has thousands of codes and subcodes describing everything from products to status'. We need to lookup and randomly populate the code and subcode in a table, however they have to correlate to each other. Like the following:

Code Subcode
PENDING | NEW SUBMISSION
PENDING | WAITING REVIEW
LOCKED | AWATING MANAGER OVERRIDE
ACTIVE | REVIEW COMPLETE

Currently if we use two "SQL Query" generators for the lookups we get codes that do not match up with the subcodes, for instance:

Lookup Code Lookup Subcode
PENDING | REVIEW COMPLETE
ACTIVE | WAITING REVIEW
PENDING | AWAITING MANAGER OVERRIDE

Unfortunately we cannot put these into a "Weighted List" as there is a third field which is used to determine which codes they are. That is why we would like to use a "SQL Query" to populate to attributes so that they match up correctly. Here's an example query:

select code, subcode from lookup_codes where code_list='APPLICATION STATUS'

I hope this is explained clear enough. Any help provided would be greatly appreciated.

Thanks,
Rob

[alexa]

Could you please provide us a sample of the database so we can provide you with a more precise answer?

Also, setting identical seed for both SQL query generators may help you.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .