Discussion Board for collaboration on QlikView Scripting.
I have 2 tables. The 2nd table I want to join to my 1st table whereever the common fields match. So to illustrate
Field a, Field b, Field c, Field D, Field E, Field F
Table2:Field D, Field E, Field F, NEWFIELD G
I want fields D, E and F to reference to where those same values appear in table 1 (So there are 3 common fields). Whenever they do it needs to then add NEWFIELD G to table 1.
Go to Solution.
I think it shouold be something like:
Field D & Field E & Field F as KEY_FIELDS,
Table2: //you can actually leave this line out
LEFT JOIN Table1
After this I think you can also do a
DROP field KEY_FIELDS FROM Table1;
to remove the KEY field
Thanks it sounds right, my model is a little complicated, so kinda realising this won't work. Need to clean things up a bit first I rate Thanks Faizoel!