Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi,
have you try to control the script loading log?
Redards.
Hi,
how to do that please.
Thanks
Neetha
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;
So Settings > Document Properties > General Tab > On the right, check Generate Log file.
This generate a txt file in the Apllication's folder.
Thanks,generate log i have idea,i was thinking any other way to control load
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?
Thanks Michael ,missed noconcatenate keyword.
Regards
Neetha