topic Re: Separating Values while lookup in QlikView

Separating Values while lookup

Saro_2306 — Tue, 03 Aug 2021 08:22:00 GMT

Input:
load * Inline [
Col1, place

1,Area/Club

2,District

3,Country/Street
];

TAB2:
Load * Inline [
Col1
1
2
3
];

My Output should be like below:

1,Area

1,Club

2,District

3,Country

3,Street

Can anybody please help. Thanks in Advance.

Re: Separating Values while lookup

Frank_Hartmann — Tue, 03 Aug 2021 08:37:51 GMT

maybe like this:

Input: Load *, subfield(place,'/') as place_new; load * Inline [ Col1, place 1,Area/Club 2,District 3,Country/Street ]; TAB2: Load * Inline [ Col1 1 2 3 ];