topic Re: Search text in string for count it in QlikView

Search text in string for count it

Sun, 07 Aug 2011 08:46:31 GMT

Hi,

I have 2 tables with values like these:

FIELD1
X_QDERE, STROE, DOGED (DA2, G33).xls
DODGE
Y_OGDSDWD, PODRTE.xls
X_STROE, GPOWDE, OGDSDWD (G0D2, ED1).xls
PODRTE, STROE

FIELD2
DOGED
GPOWDE
OGDSDWD
PODRTE
QDERE
STROE

I need to link values of FIELD2 that appear in FIELD1 and count them. So i am needing a chart with this values:

FIELD2	COUNT
DOGED	2
GPOWDE	1
OGDSDWD	2
PODRTE	2
QDERE	1
STROE	3

Hope you can help me. Thanks in advance

Re: Search text in string for count it

disqr_rm — Sun, 07 Aug 2011 15:38:28 GMT

See Enclosed.

Is this something you are looking for?

Rakesh

Re: Search text in string for count it

Sun, 07 Aug 2011 17:29:55 GMT

Thank you Rakesh, i was trying and finally have other solution, not so clean as your but it also works as expect.

FullTab:
LOAD 
    subfield(
        replace(
            replace(
                replace(
                    replace(
                        replace(
                            replace(FIELD1,',',' ')
                        ,'  ',' ')
                    ,'_',' ')
                ,'(',' ')
            ,')',' ')
        ,'.xls',' ')
    ,' ') as FIELD2,  * INLINE [
    FIELD1
    "X_QDERE, STROE, DOGED (DA2, G33).xls"
    "DOGED"
    "Y_OGDSDWD, PODRTE.xls"
    "X_STROE, GPOWDE, OGDSDWD (G0D2, ED1).xls"
    "PODRTE, STROE"
];
MatchTab:
INNER JOIN LOAD * INLINE [
    FIELD2
    DOGED
    GPOWDE
    OGDSDWD
    PODRTE
    QDERE
    STROE
    XCVDE
];