Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Nolgath
Creator
Creator

Table not found, but everything seems in order

Hello, 

I am having a issue with loading a script:

 

//Mapping table to link fields

MappingTable:
Mapping
Load
Original,Normalized
INLINE [
Original,Normalized
make,brand
model,model
variant,variant
engineType,fuelType
gearBoxType,gearbox
bodyType,chassis
];

//Link fields using mapping table

Table3:
Load
make,
model,
variant,
fuelType,
gearbox,
chassis
Resident [carDataExtended];

Left Join (MappingTable)
Load
Original,
Normalized
Resident MappingTable;

 

 

This script seems ok to me it gives me error "MappingTable" not found, but as you can see there is the table and all is ok no mistakes.

The only 2 tables I have before that are Table1 and Table2. 

Any clue why this is hapenning?

Labels (3)
1 Solution

Accepted Solutions
Gabbar
Specialist
Specialist

Using Mapping Load In a table renders it from being used differently.
in your MappingTable you have used Mapping load.
Replace Mapping Load with Load and it will work.

View solution in original post

1 Reply
Gabbar
Specialist
Specialist

Using Mapping Load In a table renders it from being used differently.
in your MappingTable you have used Mapping load.
Replace Mapping Load with Load and it will work.