topic Mapping Load Not Working? in QlikView

Mapping Load Not Working?

Thu, 16 Jun 2011 22:02:48 GMT

Can a mapping load not handle / value? I tried a few combinations by removing the spaces but can not get this mapping load to work...

Anyone else have any ideas? This is my product_line field. This should match up?

Would like the product_line to match up to 'ACP'.

Applymap('ProductLine', product_line) AS ProductType;
ProductLineMap:
MAPPING Load * Inline [
product_line, ProductType
ACP/65/3RD PRTY, ACP
ACP/70/SUPPORT, ACP
ACP/GSS C/3RD PRTY, ACP
...
];

Mapping Load Not Working?

Miguel_Angel_Baeyens — Thu, 16 Jun 2011 22:24:56 GMT

Hi,

This may be obvious but is the MAPPING LOAD table BEFORE the ApplyMap() function? If not, then you will get no errors, but the field will be empty.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Mapping Load Not Working?

Thu, 16 Jun 2011 22:36:22 GMT

Hi jjbingen

You are missing your table name:

ProductLine

Applymap('ProductLineMap', product_line) AS ProductType; CORRECT!

And i´m agree with Miguel about the MAPPING LOAD table BEFORE the ApplyMap() function

Check it out!

Regards.