topic Re: rawdata in QlikView

rawdata

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

am trying to extract raw data into qlikview.

which is in the below format.

But my desired output should be as below

Please help!!!

Re: rawdata

its_anandrjs — Wed, 04 Oct 2017 04:27:47 GMT

Find the attached

Data:

LOAD id,

name,

pickup,Upper(Right(pickup,3)) as LANDMARK

FROM

file1.xlsx

(ooxml, embedded labels, table is Rawdata) Where Len(name) <> 0;

Left Join(Data)

LOAD pickup as LANDMARK

FROM

file1.xlsx

(ooxml, embedded labels, table is Rawdata) Where Len(name) = 0;

Re: rawdata

jonathandienst — Wed, 04 Oct 2017 04:52:54 GMT

Or this (not dependant on the format/parsing of the detail pickup values):

Step1:

LOAD

id,

name,

pickup,

If(Len(name) = 0, pickup, peek(Landmark)) as Landmark

FROM rawdata....;

Result:

NoConcatenate

LOAD *

Resident Step1

Where Len(name) <> 0;

DROP Table Step1;

Re: rawdata

its_anandrjs — Wed, 04 Oct 2017 06:10:19 GMT

And also there is another way is just use Upper(Right(pickup,3)) in single table may be this if your requirement matches

Data:

LOAD id,

name,

pickup,

Upper(Right(pickup,3)) as LANDMARK

FROM

file1.xlsx

(ooxml, embedded labels, table is Rawdata) Where Len(name) <> 0;