Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

Maybe like

...

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

View solution in original post

7 Replies
Anonymous
Not applicable
Author

Loic

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

Best Regards,     Bill

swuehl
MVP
MVP

Maybe like

...

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

Not applicable
Author

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

Anyway thanks for your reply!

swuehl
MVP
MVP

Yes, but the combination with

and not [Field0_] = '!   
'

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

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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
Author

Oh thanks man, you just solved my question!