

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where Clause in Loading
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*';
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Where ITEM_DESCRIPTION like ('Internal*');

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try with :
LOAD ITEM_WH,
ITEM_ID,
ITEM_CODE,
ITEM_DESCRIPTION,
FROM
(qvd) WHERE WildMatch(ITEM_DESCRIPTION,'INTERNAL SLOT*')>0;
Regards,
Vincent

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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....!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()) )

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()) )
