Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
let us have your script or sample qvd with limited data.
it should work;
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;
Looks ok to me.. Can you attach your sample qvw?