pls check the script for noconcatenate

[#1]

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]

HI,

    I have already send you the reason for this error.

Regards,

Kaushik Solanki