Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Clause Where in a Load

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Clause Where in a Load

Maybe like

...

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

7 Replies

Re: Clause Where in a Load

Loic

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

Best Regards,     Bill

MVP
MVP

Re: Clause Where in a Load

Maybe like

...

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

Not applicable

Re: Clause Where in a Load

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

Anyway thanks for your reply!

MVP
MVP

Re: Clause Where in a Load

Yes, but the combination with

and not [Field0_] = '!   
'

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

Not applicable

Re: Clause Where in a Load

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

MVP
MVP

Re: Clause Where in a Load

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.

Not applicable

Re: Clause Where in a Load

Oh thanks man, you just solved my question!

Community Browser