No match in using Where Exist()

[janus2021]

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?

[jbhappysocks]

Hi, are you using where exist (SoktV) or is it just a typo? It needs to be where exists (SoktV)

[janus2021]

srry, just typo, i am using exists(SoktV).

[jbhappysocks]

(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
];

[MayilVahanan · Accepted solution]

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));

[janus2021]

it works, thanks.