topic Re: Mapping data issue in App Development

Mapping data issue

stekol61 — Wed, 22 May 2019 12:59:25 GMT

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

sunny_talwar — Wed, 22 May 2019 13:05:52 GMT

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

Gysbert_Wassenaar — Wed, 22 May 2019 13:21:55 GMT

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.