delimiter in script

[pandiarajan]

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

[MayilVahanan · Accepted solution]

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.

[#3]

Attached - include rowno()

[tresesco]

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]

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.