Discussion Board for collaboration on QlikView Scripting.
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?
load [Field0_] as Désignation,
[Field1_] as Emballage,
[Field2_] as Contenu,
[Field3_] as [Nb Cols],
[Field4_] as [Nb Pals],
[Field5_] as [Nb Litres]
where [Field0_] =
Go to Solution.
WHERE [Field0_] like '! ?' and not [Field0_] = '! ';
Have a look at the Wildmatch() function in the QlikView help.
Best Regards, Bill
I have already tried but there '?' can be a space so it doesn't help me.
Anyway thanks for your reply!
Yes, but the combination with
(! with four blanks) should check this case and remove these records, shouldn't it?
if i have Understood you right way, this may help you .
Just Check it out.
where WildMatch([Field0_],'! ?') and (mid([Field0_],5)<>'');
I tried it with inline Data as follows,
where WildMatch(FiledName,'! ?') and (mid(FiledName,5)<>'');
Load * INLINE [
Try like this
where [Field0_] like '! ?' AND Len(Keepchar(Mid([Field0_], 5, 1), 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')) > 0;
Hope this helps you.
Oh thanks man, you just solved my question!