Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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;
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.
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
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;