rawdata

[antonybi]

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!!!

[its_anandrjs · Accepted solution]

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;

[jonathandienst]

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;

[its_anandrjs]

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;