WHERE STATEMENT

[#1]

Hi i am wondering if anyone can help, here is what i have so far and it works,

OverViewShopOrders:

LOAD

SHOP_ORD_NO,

PART_NO,

PART_DESCRIPTION,

PROJECT_ID,

FROM

[$(FolderPath)\]

FROM

[$(FolderPath)\]

FROM

[$(FolderPath)\]

qvd

)

WHERE

PROJECT_ID = 'S07050720' ;

But i would like for the WHERE PROJECT_ID = 'S07050720' , ' S07050721 ' ;

I only want to display the two fields but an error message keeps coming up when i enter this, Any suggestion please.

Thanks

[suniljain]

Pls Try This Code

OverViewShopOrders: LOAD SHOP_ORD_NO, PART_NO, PART_DESCRIPTION, PROJECT_ID, FROM [$(FolderPath)\] FROM [$(FolderPath)\] FROM [$(FolderPath)\] qvd ) WHERE PROJECT_ID = 'S07050720' or PROJECT_ID = 'S07050721' ;

[nicole]

Hi,

try this:

where PROJECT_ID='S07050720' or PROJECT_ID='S07050721' ;

Nicole

[#4]

You can try the OR between the two values:

WHERE PROJECT_ID = 'S07050720' OR PROJECT_ID=' S07050721 ' ;

[Miguel_Angel_Baeyens]

Hello Kelly,

Check

OverViewShopOrders:LOAD SHOP_ORD_NO, PART_NO, PART_DESCRIPTION, PROJECT_ID FROM FILE.QVD (qvd) WHERE MATCH(PROJECT_ID, 'S07050720', 'S07050721') > 1

Check as well that variable "FolderPath" has the complete path to the file.

Hope that helps

[#6]

Yes the following code worked

Project_ID = 's07050720' or Project_ID = 's07050721'

Thanks very much