topic Join Field2 in Table1 to Table2 in QlikView

Join Field2 in Table1 to Table2

mazacini — Thu, 17 Nov 2011 22:42:23 GMT

I have loaded Table1. It has fields ID and VAL. ID is unique.

I have loaded Table2. It has ID and REF. There are multiple records for each ID.

Now I want to add VAL from Table1 to Table2.

I think it is LEFT JOIN, but could someone help me with the syntax?

Re: Join Field2 in Table1 to Table2

johnw — Thu, 17 Nov 2011 23:11:06 GMT

LEFT JOIN (Table2)

LOAD ID, VAL

RESIDENT Table1;

In some cases, it may be more efficient to turn Table1 into a map, and apply the map during the load of Table2.

Join Field2 in Table1 to Table2

mazacini — Thu, 17 Nov 2011 23:29:41 GMT

Thanks John

Still getting the hang of the RESIDENT.

By the way, you might be interested to see how JOIN features in the documentation - pretty sparse in the help section, and non-existent in the tutorial!

Rgds

Joe

Join Field2 in Table1 to Table2

johnw — Thu, 17 Nov 2011 23:34:05 GMT

If you go to the main Join entry in the help text, then click through on the various prefixes (inner, outer, left, right), I think it does a pretty good job there. But yeah, the main Join entry has almost no information. I guess they expect you to click through.