Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
123: LOAD * INLINE [ Empname, Organisation, flag ABC, Sumo, 1 ABC, Tata, 2 XYZ, Sofeti, 1 XYZ, Tata, 2 ]; 124: Load Empname,Organisation as Organisation1 Resident 123 where flag=1; 125: Load Empname,Organisation as Organisation2 Resident 123 where flag=2; 126: Load Distinct Empname Resident 123; Left Join(126) Load * Resident 124; Left Join(126) Load * Resident 125;
Drop Table 123,124,125;
Try the above code
hello,
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
123: LOAD * INLINE [ Empname, Organisation, flag ABC, Sumo, 1 ABC, Tata, 2 XYZ, Sofeti, 1 XYZ, Tata, 2 ]; 124: Load Empname,Organisation as Organisation1 Resident 123 where flag=1; 125: Load Empname,Organisation as Organisation2 Resident 123 where flag=2; 126: Load Distinct Empname Resident 123; Left Join(126) Load * Resident 124; Left Join(126) Load * Resident 125;
Drop Table 123,124,125;
Try the above code