Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Find attached I want to store data source I left load into one qvd what do I do?
May be this:
Class:
LOAD [S/N],
CLASS,
Descrition,
GROSS,
NET
FROM
[\Book2.xlsx]
(ooxml, embedded labels, table is Classes);
Left Join (Class)
LOAD [DT number],
Descrition
FROM
[\Book2.xlsx]
(ooxml, embedded labels, table is Link);
Left Join (Class)
LOAD
HOSTEL,
Name,
[DT number],
Cost
FROM
[\Book2.xlsx]
(ooxml, embedded labels, table is [Hostel info]);
STORE Class into Class.qvd(qvd);
use left join for all tables
andd store that into qvd.
hope this helps u
You have gone from being Sureshqv -> Chanty 4u -> suri qv in a matter of a day . Whom are you trying to hide from
hey sunny....i dnt knw now am chkng wen its chnged to suri again?
my nik name is chanty .so i chnged. while creating Qlik community login I hve givn name as suri qv.
so i changed.
I did left Join but the data in the table B are not showing after joining but if I do no concatenate it shows but I suspect its not correct.. because if it actually join it will show in the field
Not sure I understand your issue. Can you elaborate?
If I left join the data in both fields are merged right? But in this case the I cant find the data of table B in table A I join it with
It should add new columns and not rows, I hope you know that right?