Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Resident date?

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


DateFileAuto number
01/01/2016Applications1
01/01/2016Checking1
01/01/2016Validation1
01/02/2016Applications2
01/02/2016Checking2
01/02/2016Validation2
01/03/2016Checking3
01/04/2016Applications4
01/04/2016Validation4



1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

3 Replies
swuehl
MVP
MVP

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
Not applicable
Author

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

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;