Store Date field from multiple tables

[tamilarasu]

Hi,

I have four tables in load script and each table linked with common field %date. I want to store this field in a table, so that I can create a master calendar, My source looks like below.

T1:

Load %date,

CustData1

From

Data1;

T2:

Load %date,

CustData2

From

Data2;

T3:

Load %date,

CustData3

From

Data3;

Can anyone suggest me a load script for this.

Thank you.

[rubenmarin]

Hi Tamil, if the field is called %date in all tables, the FieldValue() and FieldValueCount() functions will count the values in all the tables.

As I saw in your recently posted script the name is %Date (with uppercase 'D'), change '%date' to your field name.