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

Search text in string for count it

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:

FIELD2COUNT
DOGED2
GPOWDE1
OGDSDWD2
PODRTE2
QDERE1
STROE3

Hope you can help me. Thanks in advance

1 Solution

Accepted Solutions
disqr_rm
Partner - Specialist III
Partner - Specialist III

See Enclosed.

Is this something you are looking for?

Rakesh

View solution in original post

2 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

See Enclosed.

Is this something you are looking for?

Rakesh

Not applicable
Author

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

];