
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No match in using Where Exist()
Hi.
when creating a qvd, i trie only to extract rows that i want.
creates a temp table with values that a specific column must contain.
Then make the sort against the fact table and then only want out rows that contain the same values that are in the tmp table. Uses 'where excist' but gets no match.
the column type in the fact table is of the varchar(20).
tmpSelectA:
Load * inline [
SoktV
0100
0151
];
Sort_varden:
Load
Column1,
column2,
SoktV
From [//fakta.qvd] (qvd)
where Exist (SoktV)
Gets no hit, has also tried to set values ??in tmpSelectA as '0100' but it does not work either.
Suggestions?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Janus,
Try like below
tmpSelectA:
Load *, Text(Soktv) as SoktvText inline [
SoktV
0100
0151
];
Sort_varden:
Load
Column1,
column2,
SoktV
From [//fakta.qvd] (qvd)
where Exist (SoktvText , Text(SoktV));
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, are you using where exist (SoktV) or is it just a typo? It needs to be where exists (SoktV)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
srry, just typo, i am using exists(SoktV).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
(Deleted an earlier reply as it did not in any way answer your actual question)
Have you tried removing the initial 0 from your inline?
tmpSelectA:
Load * inline [
SoktV
100
151
];

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Janus,
Try like below
tmpSelectA:
Load *, Text(Soktv) as SoktvText inline [
SoktV
0100
0151
];
Sort_varden:
Load
Column1,
column2,
SoktV
From [//fakta.qvd] (qvd)
where Exist (SoktvText , Text(SoktV));
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it works, thanks.
