topic Re: Multiple Loads in One Table in QlikView

Multiple Loads in One Table

Fri, 23 May 2014 04:05:26 GMT

Hello!

I have the following table on my model:

MasterDateTable:

Load Date_Key,

DATE_PLANNED as Date,

'Planned' as Type

Resident Link;

Load Date_Key,

DATE_CANCELLED as Date,

'Cancelled' as Type

Resident Link;

Load Date_Key,

DATE_TESTED as Date,

'Tested' as Type

Resident Link;

Load Date_Key,

DATE_SENT as Date,

'Sent' as Type

Resident Link;

I wanted to know what happens when I make multiple loads for a single table, like in my case.

Is it the same to use the concatenate between every load? Or what does the multiple loads for a single table do?

Thank you!!!

Re: Multiple Loads in One Table

senpradip007 — Fri, 23 May 2014 04:31:34 GMT

If two or more tables consist of the same fields all are concatenated automatically. "Concatenate()" concatenates two tables with different fields having atleast one similar field.

load

Field1,

Field2

From [Source1];

Concatenate(A)

load

Field1,

Field3

From [Source2];

Re: Multiple Loads in One Table

Fri, 23 May 2014 04:40:42 GMT

Hi mart pabst,

if tables share common fields then it will be automatically concatenate.

MasterDateTable:

Load Date_Key,

DATE_PLANNED as Date,

'Planned' as Type

Resident Link;

Load Date_Key,

DATE_CANCELLED as Date,

'Cancelled' as Type

Resident Link;

Load Date_Key,

DATE_TESTED as Date,

'Tested' as Type

Resident Link;

Load Date_Key,

DATE_SENT as Date,

'Sent' as Type

Resident Link;

All date where assigned same name as 'Date' to connect with calender (if it's in different names cant connect)and classified by the field 'Type'.

Thank you