topic Resident date? in QlikView

Resident date?

Anonymous — Thu, 11 Aug 2016 21:53:58 GMT

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

Re: Resident date?

swuehl — Thu, 11 Aug 2016 21:57:16 GMT

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.

Re: Resident date?

Anonymous — Fri, 12 Aug 2016 10:36:18 GMT

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

Re: Resident date?

sunny_talwar — Fri, 12 Aug 2016 10:39:36 GMT

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;