pls check the script for noconcatenate

Thu, 30 Jun 2011 05:53:08 GMT

Hi to all,

When I am trying to execute below script in QVW file getting an error "Table Not Found" for 2010.

2011:

LOAD Id,
Date,
Lot
FROM
[New Microsoft Excel Worksheet.xls]
(biff, embedded labels, table is [2011$]);

NoConcatenate

Load Distinct
Lot as Lotnum
Resident 2011;
----------------------------------

2010:

LOAD Id,
Date,
Lot
FROM
[New Microsoft Excel Worksheet.xls]
(biff, embedded labels, table is [2010$]);

NoConcatenate

Load
Lot as Lotnum
Resident 2010;

Actually my requirement is to maintain no concatination between Lot and Lotnum. i.e; when i select Lot field then Lotnum field should not effect.

How can i overcome this error. Pls check the below QVW file.

Regards

ravi

kaushiknsolanki — Thu, 30 Jun 2011 06:23:23 GMT

HI,

I have already send you the reason for this error.

Regards,

Kaushik Solanki

topic pls check the script for noconcatenate in QlikView