Lookup Columns - Support - RS Data Extension

Search Forum Home

Forum

Enesys RS Data ...

Support - RS Da...

Lookup Columns

1/20/2010 4:20 PM

dchillman

Joined: 6/13/2009

Posts: 1

Lookup Columns

in the users guide it states that for lookup columns the enesys data extension will add 2 columns to the dataset for lookup columns, one with the value (ColumnName) and the other with the associated ID (ColumnNameID). However, when I create a dataset from a list that has a lookup column I am only seeing one column in the column selection tab. Is there a trick to seeing the other column? I am using the latest version of the data extension.

1/20/2010 4:40 PM

Marien Monnier

Joined: 4/15/2008

Posts: 55

Re: Lookup Columns

Modified By Marien Monnier on 1/20/2010 5:42:10 PM

Hello,

The second column containing the ID is not displayed in the Columns tab. If you want to return the Lookup ID, you just have to select the Lookup column. The associated ID will be automatically added to the results in a second column.

For your information, if you need to filter the data according to the Lookup ID, you have to set the LookupId to true inside the condition.

Don't hesitate to contact us if you need more information.

Regards,
Marien Monnier

Page 1 of 1