Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Mapping data issue

Hi!

I have loaded data from an Excel file for Service level for some different system.

The data 'Item SLA' is merged in the load script together with ticked data for some different systems.

The problem is that the 'Item' objects in the ticked data  sometimes are spelled differently, E.g 'Temip' and 'TeMIP'.

Then the mapping doesn't work.

How can this be solved?

/Stefan

SLA from Excel.PNG

SLA mapping.PNG

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Temip and TeMIP are different values. You'll have to either make them all the same or add another record in your mapping table for Temip.

talk is cheap, supply exceeds demand

View solution in original post

2 Replies
sunny_talwar

May be make both of them Upper, lower, or Capitalize

Gysbert_Wassenaar

Temip and TeMIP are different values. You'll have to either make them all the same or add another record in your mapping table for Temip.

talk is cheap, supply exceeds demand