Clause Where in a Load

[#1]

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

[Anonymous]

Loic

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

Best Regards,     Bill

[swuehl · Accepted solution]

Maybe like

...

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

[#4]

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

Anyway thanks for your reply!

[swuehl]

Yes, but the combination with

and not [Field0_] = '!

'

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

[#6]

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

[jagan]

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.

[#8]

Oh thanks man, you just solved my question!