values are loading as date

[vireshkolagimat]

Hi team,

I have below data and after loading into qlikview, the values are loading as dates like the header column.

Kindly help me to resolve this. and also how to keep the date as header.

prod  1/1/2016   5/1/2016  change

A       200        300          100

B      50          100           50

C      500        300           200

thanks

Viresh

[vireshkolagimat]

I am using Qualify statement to avoid synthetic key. The code works if i don't use the qualify statement but will not get the expected result if i use Qualify statement. How to deal in this case.

[sunny_talwar]

why are you renaming it to just square brackets here???? Not sure I still understand your issue... can you provide the script you have and what the concern is?

[vireshkolagimat]

Hi,

I have more than 8 tables which contain 5 to 6 column which are common in each table. So while loading the data, to avoid synthetic keys i am using qualify * statement. My load script looks like below.

table1:

Load *

From table.slsx;

qualify *;

table2:

Load *

from table2.xlsx;

unqualify *;

Qualify *;

Table3:

Load *

from tabl3.xlsx;

Unqualify *;

the script you gave works fine for a single table. When i tried to use the script in the above case, it is not working as expected. Let me know if you need any details.

thanks for your support.

Regards,

Viresh