lookup scenario

[vijetas42]

Hi everyone,

I am having tables,

t1:                       

id1,id2,value

A,1,100

B,2,120

C,3,140

t2:

id1,pg1

A,pqr

B,

D,xyz

E,123

t3:

id2,pg2

1,abc

2,mno

3,tuv

4,xyz

after joining I want output like,

id1,id2,pg1,value

A,1,pqr,100

B,2,mno,120

how should I achieve it?

[MK_QSL]

let us have your script or sample qvd with limited data.

it should work;

[vijetas42]

I am doing this way,

t3:

Mapping LOAD id2,

     pg1

FROM

D:\Qvds\t3.xlsx

(ooxml, embedded labels, table is Sheet1);

T1: 

LOAD id1,

     id2,

     val

FROM

D:\Qvds\t1.xlsx

(ooxml, embedded labels, table is Sheet1)Where Match(id1,'A','B');

Inner join

t2:

LOAD id1,

     pg1

FROM

D:\Qvds\t2.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Final:

LOAD

id1,id2,

IF(pg1='',ApplyMap('t3',id2),pg1) as pg1,val  Resident T1;

Drop Table T1;

[MK_QSL]

Looks ok to me.. Can you attach your sample qvw?