Discussion board where members can get started with QlikView.
LOAD * INLINE [
Empname, Organisation, flag
ABC, Sumo, 1
ABC, Tata, 2
XYZ, Sofeti, 1
XYZ, Tata, 2
Load Empname,Organisation as Organisation1 Resident 123 where flag=1;
Load Empname,Organisation as Organisation2 Resident 123 where flag=2;
Load Distinct Empname Resident 123;
Load * Resident 124;
Load * Resident 125;Drop Table 123,124,125;
Try the above code
View solution in original post
if the data is already in qv, can't use binary ?
in that case, you load the data in a new .qvw, in which you could use cross load