topic Re: Clause Where in a Load in QlikView

Clause Where in a Load

Wed, 20 Nov 2013 10:53:51 GMT

Hello,

I am a rookie in Qlikview and i need help for a point.

I want to load some lines from a table into another.

The lines i want to load in the new table must contain the char '!', then 3 spaces (like ' ') and then 1 char which can't be a space

It must be something like '! ?' with ?<>' '

Can someone help me to write this correctly in the where clause of the load like i show below?

table:

load [Field0_] as Désignation,

[Field1_] as Emballage,

[Field2_] as Contenu,

[Field3_] as [Nb Cols],

[Field4_] as [Nb Pals],

[Field5_] as [Nb Litres]

resident previousTable

where [Field0_] =

Thanks,

Regards,

Loïc

Re: Clause Where in a Load

Anonymous — Wed, 20 Nov 2013 10:59:29 GMT

Loic

Have a look at the Wildmatch() function in the QlikView help.

Best Regards, Bill

Re: Clause Where in a Load

swuehl — Wed, 20 Nov 2013 11:00:22 GMT

Maybe like

...

WHERE [Field0_] like '! ?' and not [Field0_] = '! ';

Re: Clause Where in a Load

Wed, 20 Nov 2013 11:08:10 GMT

I have already tried but there '?' can be a space so it doesn't help me.

Anyway thanks for your reply!

Re: Clause Where in a Load

swuehl — Wed, 20 Nov 2013 11:12:05 GMT

Yes, but the combination with

and not [Field0_] = '!

(! with four blanks) should check this case and remove these records, shouldn't it?

Re: Clause Where in a Load

Wed, 20 Nov 2013 11:14:58 GMT

Hi Loic_dev,

if i have Understood you right way, this may help you .

Just Check it out.

table:

load [Field0_] as Désignation,

[Field1_] as Emballage,

[Field2_] as Contenu,

[Field3_] as [Nb Cols],

[Field4_] as [Nb Pals],

[Field5_] as [Nb Litres]

resident previousTable

where WildMatch([Field0_],'! ?') and (mid([Field0_],5)<>'');

I tried it with inline Data as follows,

Data:

Load FiledName

where WildMatch(FiledName,'! ?') and (mid(FiledName,5)<>'');

Load * INLINE [

FiledName

! @

Asia

! <

! >

! ?

Europe

! *

];

Regards,

Ravikant

Re: Clause Where in a Load

jagan — Wed, 20 Nov 2013 11:22:34 GMT

Hi,

Try like this

table:

load [Field0_] as Désignation,

[Field1_] as Emballage,

[Field2_] as Contenu,

[Field3_] as [Nb Cols],

[Field4_] as [Nb Pals],

[Field5_] as [Nb Litres]

resident previousTable

where [Field0_] like '! ?' AND Len(Keepchar(Mid([Field0_], 5, 1), 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')) > 0;

Hope this helps you.

Regards,

Jagan.

Re: Clause Where in a Load

Wed, 20 Nov 2013 11:45:14 GMT

Oh thanks man, you just solved my question!