Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
| FIELD2 | COUNT |
|---|---|
| DOGED | 2 |
| GPOWDE | 1 |
| OGDSDWD | 2 |
| PODRTE | 2 |
| QDERE | 1 |
| STROE | 3 |
Hope you can help me. Thanks in advance
See Enclosed.
Is this something you are looking for?
Rakesh
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
];