Hi master calendar?

[#1]

I have 2 tables  and each table having starting date and ending date ?

t1:

load* inline[

starting date,endingdate,

.

.

.

.

];

t2:

load* inline[

starting date,endingdate,

.

.

.

.

];    filed names are ame and inside dates are different from each table.  so  now  i want create a master calendar for this ? how ?

can i join this table or concatenate?  is there any other way?

[jagan]

Hi,

Try like this

t1:

load* inline[

starting date,endingdate,

.

.

.

.

];

Concatenate

load* inline[

starting date,endingdate,

.

.

.

.

];

Noconcatenate

Calendar:

LOAD DISTINCT

*

RESIDENT t1;

DROP TABLE t1;

Now create required date field in Calendar table.

Regards,

jagan.

[#3]

can u give script for this scenario map calendar

[Anonymous]

Hi,

You can use Concatenate here and since starting date and ending date are different in each table, you can use flag to distinguish them.

Calendar:

load* inline[

starting date,endingdate,

'table1' as table_flag,

.

.

.

.

];

Concatenate

load* inline[

starting date,endingdate,

'table2' as table_flag,

.

.

.

.

];

[jagan]

Hi,

Check this link, hope it helps you.

Master Calendar Generation Script

Regards,

Jagan.

[senpradip007]

Try with this qvw.