Hi

[Anonymous]

Hi

I am getting an error while executing a particular script.

I am attaching the error and the script.

Can please somebody help me?

Thanks

Mahendra

[sunny_talwar]

Try this

[Aircraft Types]:
Map_Manufacturer_Country:
Mapping

LOAD Company,
    Country
FROM
[..\Data Files\CSVs\Aircraft_Manufacturers.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[Aircraft Types]:
LOAD
AC_TYPEID as [%Aircraft Type ID],
    AC_GROUP as [%Aircraft Group Type],
    SSD_NAME as [Aircraft Name],
    MANUFACTURER as [Aircraft Manufacturer],
    applymap('Map_Manufacturer_Country',MANUFACTURER,'Unknown')as [Aircraft Manufaccturer Country],
    LONG_NAME as [Aircraft Name Full],
    SHORT_NAME as [Aircraft Name Abbreviated],
    BEGIN_DATE as [Aircraft Begin Date],
    END_DATE as [Aircraft End Date]
   
   
FROM
[..\Data Files\CSVs\Aircraft_Base_File.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Left Join ([Aircraft Types])
LOAD [Aircraft Group ID] as [%Aircraft Group Type],
    [Aircraft Engine Type],
    [Aircraft Number Of Engines]
FROM
[..\Data Files\CSVs\Aircraft_Group.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

DROP Field [%Aircraft Group Type] from [Aircraft Types];

Concatenate ([Aircraft Types])
LOAD AC_TYPEID as [%Aircraft Type ID],
    subfield (AC_GROUPNAME,',',1)as [Aircraft Engine Type],
    subfield (AC_GROUPNAME,',',2)as [Aircraft Number of Engines],
    SSD_NAME as [Aircraft Name],
    MANUFACTURER as [Aircraft Manufacturer],
    applymap('Map_Manufacturer_Country',MANUFACTURER,'Unknown')as [Aircraft Manufacturer Country],
    LONG_NAME as [Aircraft Name Full],
    SHORT_NAME as [Aircraft Name Abbreviated],
    BEGIN_DATE as [Aircraft Begin Date],
    END_DATE as [Aircraft End Date]
FROM
[..\Data Files\CSVs\Aircraft_2010_Update.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[shiveshsingh]

I think you have misplaced the table name, try putting the name in highlighted place and reload.

[andrei_delta]

hi,

[Aircraft Types]:
Map_Manufacturer_Country:
Mapping LOAD Company,
Country
FROM
[..\Data Files\CSVs\Aircraft_Manufacturers.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

  The problem is that you overwrote the name of the table by placing "Map_Manufacturer_Country:" after the name you wanted for your table "[Aircraft Types]:".

  Therefore the error of not find your designated table.

Hope it helps,

Andrew