Hi

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Hi

sunny_talwar — Fri, 13 Apr 2018 02:39:01 GMT

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);

Re: Hi

shiveshsingh — Fri, 13 Apr 2018 05:32:17 GMT

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

Re: Hi

andrei_delta — Fri, 13 Apr 2018 09:15:14 GMT

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

topic Hi in QlikView

Hi

Re: Hi

Re: Hi

Re: Hi