Multiple Loads in One Table

[#1]

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!!!

[senpradip007]

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.

A:

load

     Field1,

     Field2

From [Source1];

Concatenate(A)

load

     Field1,

     Field3

From [Source2];

[#3]

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