Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Loic
Have a look at the Wildmatch() function in the QlikView help.
Best Regards, Bill
Maybe like
...
WHERE [Field0_] like '! ?' and not [Field0_] = '! ';
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
and not [Field0_] = '! | ' |
(! with four blanks) should check this case and remove these records, shouldn't it?
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
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.
Oh thanks man, you just solved my question!