topic Help with Join and resident tables in QlikView

Help with Join and resident tables

Wed, 10 Mar 2010 15:44:12 GMT

Hi,

I am trying to join 2 tables into 1 table, using the 'Join'.

Then I want to use this 1 table, to create another table using Resident.

My qvw only has about 10 000 or so records, but carry's on running past 10 000 when it starts on the Resident table.

Any suggestions as to what could be the problem with my script?

I've attached the sample I am working on.

Much appreciated!

Xena

Help with Join and resident tables

Thu, 11 Mar 2010 16:45:37 GMT

Hi Xena,

This is the code I suppose is the right one (the join will be done using the Ord field):


FITEM:
LOAD Day,
 FITEM,
 Month,
 ord,
 OSTAT,
 planner,
 SHPKT,
 SSTDT,
 Year

FROM
C:\Users\Guest\Desktop\ALL.xlsx
(ooxml, embedded labels, table is Sheet1);
INNER JOIN
//CITEM:
LOAD ord,
 ACREC,
 CITEM,
 cstart,
 CUROP,
 ODUDT,
 ORDNO,
 ORQTY,
 OSNOA,
 PLANN,
 SEQD

FROM
C:\Users\Guest\Desktop\ALL.xlsx
(ooxml, embedded labels, table is Sheet1);

I hope this helps you.

Best regards.

Help with Join and resident tables

Thu, 11 Mar 2010 18:24:49 GMT

Or depending on what you want with the JOIN, you can also use a LEFT JOIN, RIGHT JOIN or OUTER JOIN.

Help with Join and resident tables

Thu, 11 Mar 2010 18:46:40 GMT

You can also use concatenate (table name) if you are just wanting to merge two tables together but not "limit" data.