Discussion Board for collaboration related to QlikView App Development.
having Table fields
- Table1.A with Values A, B, C, D, *- Table2.A with Values A, B, C, D, E, F
What I want to reach in load script is that- Table1.A values join to identical Table2.A values except for value *- Table1.A value * shall join with ANY value of Table2.
Thus result of LEFT JOIN(Table1) load Distinct A as Table1.A from Table2 should be:
I tried with Star Is command, it does not help. I cannot remember to correct way to do this,however I remember there should be a simple solution...
Thx - Marcel
Table1: load * inline [
Table2: NoConcatenate load * inline [
NoConcatenate load *, Field as Field1 Resident Table1 Where Field <> '*';
left join(Final) load * Resident Table2;
Concatenate (Final) load * Resident Table2 where not Exists(Field1, Field);
DROP Field Field1;
DROP Table Table1, Table2;
thank you for this solution. It is of course possible to split tables and apply different join conditions etc.
However, I thought there was a simpler solution needing 1 script statement only. If this is not the case, your
solution is of course ok.
Regards - Marcel