Mapping Load Not Working?

[#1]

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
...
];

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

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.