topic Re: Want to comapare two string in QlikView

Want to comapare two string

SunilChauhan — Sat, 02 Mar 2013 08:22:21 GMT

I have two table

Name, flag

Neil T,1

Tom k,1

and

SName

Tom k wahis

Neil T

Neil T katt

Tom k

now i want to compare and write flag value infront of sName.

if full string match or substring match .then i want below

SName,Flag

Tom k wahis,1

Neil T,1

Neil T katt,1

Tom k,1

ex: Neil T and substring of Neil T katt in field Sname is matching with Neil T in Name.

hence the flag infront of Neil T in Name should assign to

Neil T

Neil T katt

this is what i required.

Re: Want to comapare two string

rbecher — Sat, 02 Mar 2013 09:50:22 GMT

Hi,

you could do this with MapSubstring() to build a lookup with substring matching (even if it looks a bit strange in code):

T1:
LOAD * INLINE [
    Name, flag
    Neil T, 1
    Tom k, 1
    Neil U, 2
    Tom l, 3
];
// added some more test cases:
T2:
NOCONCATENATE LOAD * INLINE [
    Name
    Tom k wahis
    Neil T
    Neil T  katt
    Tom k
    Neil U fre
    Tom l xy
    Neil V
    Tom m
];
MapName:
Mapping LOAD '#' & Name, flag & ';' Resident T1; // # = only match from left
SName:
NOCONCATENATE LOAD Name, if(left(flag,1)='#', Null(), flag) as flag;
LOAD Name, SubField(MapSubString('MapName', '#' & Name), ';', 1) as flag
Resident T2;
Drop Tables T1, T2;

- Ralf

Re: Want to comapare two string

SunilChauhan — Sun, 03 Mar 2013 15:15:27 GMT

I salute your idea man