Need your support

[#1]

Hi experts,

I'm new to qlikview and I've attached snapshots both source and business intelligence plan.

We are getting an error while trying these.

I request to help me in detail if anyone knows.

[nizamsha]

In Source Table u have a Field have [Category ID],but u have taken catID have a look at it

cat_map:

mapping LOAD * INLINE [

    cat_id, cat_type

    1, clothing

    2, clothing

    3, clothing

    4, clothing

    5, footwear

    6, footwear

    7, clothing

    8, clothing

];

LOAD [Category ID],

    CategoryName as Category,

    Description,

    ApplyMap('cat_map',[Category ID],'unknown') as cat_type;

SQL SELECT *

FROM Categories;