Help with Join and resident tables

[#1]

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

[#2]

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.

[#3]

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

[#4]

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