topic Re: Subfield Function in QlikView

Subfield Function

wassimharfoush — Mon, 17 Oct 2016 18:57:46 GMT

Hi All ,

I am trying to Subfield field name State to get state name only

The field State looks like

State

Alabama Department of rev

North Carolina Department of revenue

Georgia Stat tax Department

New Jersey Divisions of taxation

What I am trying to get is

State

Alabama

North Carolina

Georgia

New Jersey

Please advise.

Thanks

Re: Subfield Function

MarcoWedel — Mon, 17 Oct 2016 22:59:26 GMT

Hi,

maybe one solution could be;

mapStates:
Mapping LOAD State, '@start@'&State&'@end@'
FROM [https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States] (html, codepage is 1252, embedded labels, table is [States of the United States In North America]);

tabDep:
LOAD *,
    TextBetween(MapSubString('mapStates',Department),'@start@','@end@') as State
INLINE [
    Department
    Alabama Department of rev
    North Carolina Department of revenue
    Georgia Stat tax Department
    New Jersey Divisions of taxation
];

hope this helps

regards

Marco

Re: Subfield Function

wassimharfoush — Mon, 17 Oct 2016 23:17:59 GMT

Thank you Marco !

Re: Subfield Function

MarcoWedel — Tue, 18 Oct 2016 22:39:20 GMT

you're welcome

regards

Marco