Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pandiarajan
Contributor

delimiter in script

Dear friends,

My Original Table

Branch          Employees  

Agra             aaa|aaa|bbb|CCC

Patna          AAA|ccc


Result Shoul Be


Branch   Employees

Agra       aaa

Agra       aaa

Agra       bbb

Agra       CCC

Patna     AAA

Patna     ccc


if i was use subfield

Branch   Employees

Agra       aaa

Agra       bbb

Agra       CCC

Patna     AAA

Patna     ccc


but i need


Branch   Employees

Agra       aaa

Agra       aaa

Agra       bbb

Agra       CCC

Patna     AAA

Patna     ccc


please help me someone


Tags (1)
1 Solution

Accepted Solutions

Re: delimiter in script

Hi

Try like this

Load SubField(Employees,'|') As Employess, Branch;

LOAD * INLINE [

    Branch,Employees 

    Agra,   aaa|aaa|bbb|CCC

    Patna,AAA|ccc

];

And in chart

Branch, Employees  as dimension

count(Employees) as exp

You can see the "2" count for aaa..

or

You can see the values in table viewer.

4 Replies

Re: delimiter in script

Hi

Try like this

Load SubField(Employees,'|') As Employess, Branch;

LOAD * INLINE [

    Branch,Employees 

    Agra,   aaa|aaa|bbb|CCC

    Patna,AAA|ccc

];

And in chart

Branch, Employees  as dimension

count(Employees) as exp

You can see the "2" count for aaa..

or

You can see the values in table viewer.

Not applicable

Re: delimiter in script

Attached - include rowno()

MVP
MVP

Re: delimiter in script

SubField would give you that. May be you are getting confused in the front-end, because table box shows unique records. rather check frequency in list box. See attached.

whiteline
Honored Contributor II

Re: delimiter in script

Hi.

The subfield function works as supposed.

I guess you check the data with the table box. It shows only unique combinations, so you just don't see that there are two records in the table.

Open the table view to check it or use chart straight table instead of table box.

Community Browser