Mapping

[#1]

Hi Experts,

i m trying to do applymap to change the text in my table

My script below:

MapName:

Mapping

LOAD * inline[

ActualName,   RedefinedName

Sales Records, Sales

Credits Records, Credits

];

TableA:

Load ...,

ApplyMap('MapName',[Record Name]) as [Record Name]

from...qvd;

when i try this the text has not changed.

i cant find what is wrong here.

can anyone please help me.

[chetansehgal]

Can you please share the data or sample qvw.?

[Chanty4u]

Add resident . am not sure

like sample

Map_Price: //Mapping Table

Mapping LOAD * INLINE [

    Category, Price

    Adult, 10

    Child, 5

    Student, 6

    Senior, 6

    LoyalMember, 5

];

Tickets:

LOAD * INLINE [

    Name, Class

    Ann, Student

    David, Adult

    Sara, Senior

    Keith, Child

    Tom, Adult

    Dave, Student

    Sam, Adult

    Monica, LoyalMember

    Ethan, Student

    Rose, Child

];

Price:

Load

Name,

Class,

ApplyMap('Map_Price',Class) as TicketPrice     //Here we use applymap to look up for the ticket prices

Resident

Tickets;

Drop Table Tickets;

[Chanty4u]

chk this

[Clever_Anjos · Accepted solution]

Try this

ApplyMap('MapName',Replace(Trim([Record Name]),'  ',' )) as [Record Name] // trimming and removing double spaces

[sunny_talwar]

Can you share a list box where we can see Record Name from your qvd? I think there might be name mismatch between the mapping table and Record Name field