Where Clause in Loading

[uttamdwibedy]

Hi EveryOne,

I want to load the specific data from a Qvd in which the Item decsription is start with "Internal" and other data which are not begin with "Internal" will not load into my model. So for this I have tried the below at the time of loading , but not worked. Pls. help me..!!

LOAD ITEM_WH,

     ITEM_ID,

     ITEM_CODE,

     ITEM_DESCRIPTION,

FROM

(qvd) WHERE (LEFT(ITEM_DESCRIPTION,13)='INTERNAL SLOT*';

[#2 · Accepted solution]

Try

Where ITEM_DESCRIPTION like ('Internal*');

[vincent_ardiet]

Hi,

Try with :

LOAD ITEM_WH,

     ITEM_ID,

     ITEM_CODE,

     ITEM_DESCRIPTION,

FROM

(qvd) WHERE WildMatch(ITEM_DESCRIPTION,'INTERNAL SLOT*')>0;

Regards,

Vincent

[jagan]

Hi,

Try like this

LOAD ITEM_WH,

     ITEM_ID,

     ITEM_CODE,

     ITEM_DESCRIPTION    

FROM

(qvd)

WHERE ITEM_DESCRIPTION LIKE 'INTERNAL SLOT*';

OR

LOAD ITEM_WH,

     ITEM_ID,

     ITEM_CODE,

     ITEM_DESCRIPTION    

FROM

(qvd)

WHERE WildMatch(ITEM_DESCRIPTION, 'INTERNAL SLOT*');

Hope this helps you.

Regards,

Jagan.

[uttamdwibedy]

Thanks a lot Dear lakhina007 and Vincent Ardiet....!!

I think Still you Persons will be there any Begnieer like me will not at trouble any time..!!

thanks again for your valuable time....!!

[#6]

Hi

can we use In clause for comparing with more than one value in place of like.

I need to use it like :

....
from
[Snapshot.qvd]
(qvd) where
date(floor([LoadDate]), 'DD/MM/YYYY') in (
SELECT     fulldate   FROM Date] where  year(date) = YEAR(GETDATE()) )

[jagan]

You can try using Match() like below

from
[Snapshot.qvd]
(qvd) where
Match(date(floor([LoadDate]), 'DD/MM/YYYY') , 'Date1', 'Date2')
SELECT     fulldate   FROM Date] where  year(date) = YEAR(GETDATE()) )