retrieve just some values from two fields with exists

[#1]

hello

i want to retrieve juste a some values from two fields

load * INLINE [

RECEIVER_REPORTING_PARTY_NAME

DC_NY

];

Load * INLINE [

CONFIRMATION_STATUS

TraMarket

TraPaper

] ;

in the load instruction :

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS)'.

but it seems not work because in the GUI, i have  all values for the field CONFIRMATION_STATUS

Regards,

[#2]

Generally In the above example there is no data to be loaded because RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS don't have common values on the Inline tables.

The Exists will work only to load the common values or not with given field names.

As per my understnading, you need to load only specific values & list of values are static, try like below:

FIELDVALUELISTTABLE:

LOAD * INLINE [

FIleterValues

value1

value2

value3

];

LOAD

     Field1,

     Field2

     ..

     ..

     ..

     ..

From TableName.qvd

Where ( FilterValues , [FieldNameapply the filter] );

DROP Table FIELDVALUELISTTABLE;

If you still have questions, please post script and clearly explain the requirements & whats probelm u r facing.

[maxgro]

try this to understand how exists works

a:

load * INLINE [

RECEIVER_REPORTING_PARTY_NAME

DC_NY

TraMarket

];

b:

Load * INLINE [

CONFIRMATION_STATUS

TraMarket

TraPaper

]

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS);

[#4 · Accepted solution]

thanks massimo grossi.

yes i will try it.

for my problem i thinks i can do this :

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME ) and Exist (CONFIRMATION_STATUS)

i will keep you updated