Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have Codes like below in one column.
Codes |
ACY, AEN, CK5, CLN, CS7 |
ACY, CK5, CLN, CS7 |
AEN |
AEN, CHD |
AEN, CHD |
AEN, CHD, CK5, CLP |
AEN, CHD, CLP, XDB |
AEN, CLP |
AEN, JFF, XDB |
AEN, XDB |
CBQ |
CBS, CLP |
CHD |
CHD, CK5, CLP |
CHD, CK5, CLP |
I would like to count each code like below.
Code | Count |
ACY | |
AEN | |
CBQ | |
CBS | |
CHD | |
CK5 | |
CLP | |
JFF | |
XDB | |
CS7 | |
CLN |
What I have to use it in measure & dimension?
Appreciate your help.
After the Codes table is loaded in your load script, add the following:
SingleCodes:
Load SubField(Codes,',') as SingleCode,
Codes
Resident Codes;
Then you can use SingleCode as your dimension in your table and Count(Codes) as your measure.
After the Codes table is loaded in your load script, add the following:
SingleCodes:
Load SubField(Codes,',') as SingleCode,
Codes
Resident Codes;
Then you can use SingleCode as your dimension in your table and Count(Codes) as your measure.
Thanks a lot Gary. I got an output as required.🙏