Resident date?

[Anonymous]

Hi guys,

I have data from three seperate sources

Load

PIN

Application_Medium

Application_date

FROM

(ooxml, embedded labels, table is [Results]);

Load

PIN

Application_Medium

Application_date

FROM

(ooxml, embedded labels, table is [Results]);

Load

PIN

Application_Medium

Application_date

FROM

(ooxml, embedded labels, table is [Results]);

I'm looking to produce an autonumber using the Autonumber field. If it was just one table i'd simply add autonumber to the load script of that table but I cant do this because it's three tables. My question is - once the data from the three tables has been loaded in; how can i then add an autonumber. Do i use a resident function?

What i'd like to see in the end is this

Date	File	Auto number
01/01/2016	Applications	1
01/01/2016	Checking	1
01/01/2016	Validation	1
01/02/2016	Applications	2
01/02/2016	Checking	2
01/02/2016	Validation	2
01/03/2016	Checking	3
01/04/2016	Applications	4
01/04/2016	Validation	4

[swuehl]

Maybe you can use a RESIDENT LOAD, but maybe you don't need it. Based on what criteria do you want to assign the auto number to your records?

Maybe use just a

LOAD

     Recno() as Autonumber,

     ...

in your three table loads.

edit:

If your autonumber is based on date, a

LOAD

     Autonumber(Application_Date) as Autonumber,

     ...

should work, the autonumber()  is done across multiple table loads as well.

[Anonymous]

Im not explaining myself well.

I have dates in two tables.

Table1:

01/01/2016

01/03/2016

Table2:

01/02/2016

I want to combine those dates and autonumber from earliest to latest so I have

01/01/2016 - date 1

01/02/2016 - date 2

01/03/2016 - date 3

[sunny_talwar · Accepted solution]

May be something like this:

Table:

LOAD Date

FROM Table1:

Concatenate (Table)

LOAD Date

FROM Table2;

FinalTable:

LOAD Date,

          AutoNumber(Date) as Date#

Resident Table

Order By Date;

DROP Table Table;