Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Attached - include rowno()
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.
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.