topic Re: Load Two dates issue in QlikView

Load Two dates issue

Anonymous — Wed, 17 Jun 2015 10:40:57 GMT

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

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 10:47:02 GMT

Hi,

have you try to control the script loading log?

Redards.

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 10:49:32 GMT

Hi,

how to do that please.

Thanks

Neetha

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 10:52:13 GMT

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;

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 10:58:42 GMT

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

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

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 11:03:05 GMT

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

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 11:11:00 GMT

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?

Re: Load Two dates issue

Anonymous — Wed, 17 Jun 2015 11:21:10 GMT

Thanks Michael ,missed noconcatenate keyword.

Regards

Neetha