Load Two dates issue

[Anonymous]

Hi All,

if i load two dates Date1 and Date2 in same load, fields A,B,C and Date2 are not loading.

Data:

Load A,
B,
C,
Date1,
Date2,
Value
Resident Temp1;

else if i use two loads for two dates problem concatenating,they are not combined.

Data:
Load A,
B,
C,
Date1,
Value
Resident Temp1;

Concatenate(Data)
Load A,
B,
C,
Date1,
Value
Resident Temp1;

Please any help is much appreciated.

Thanks

Neetha

[Anonymous]

Hi,

have you try to control the script loading log?

Redards.

[Anonymous]

Hi,

how to do that please.

Thanks

Neetha

[Anonymous · Accepted solution]

There is nothing wrong here

Data:

Load A,
B,
C,
Date1,
Date2,
Value
Resident Temp1;

But, it is a possibility that it auto-concatenates with the previously loaded table (I don't see all your script, so just guessing).  Try adding NOCONCATENATE:

Data:

NOCONCATENATE Load A,
B,
C,
Date1,
Date2,
Value
Resident Temp1;

[Anonymous]

So Settings > Document Properties  > General Tab  > On the right, check Generate Log file.

This generate a txt file in the Apllication's folder.

[Anonymous]

Thanks,generate log i have idea,i was thinking any other way to control load

[Anonymous]

Hi,

but in the log do you find anything strange?

Have you control the setting SET in the script for the date format?

Can you post sample data?

[Anonymous]

Thanks Michael ,missed noconcatenate keyword.

Regards

Neetha