Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Pasted Values in Lookup don't find a match even when they look exact.

Pasted Values in Lookup don't find a match even when they look exact. 9 months 4 weeks ago #18739

I have been building a transformation and I have a lot of lookup tables. My problem is that if I copy a value from a cell in Excel and then paste that value into the Lookup key field, in a lookup control, everything looks fine. However, when the incoming data looks like it is an exact match to the key field data, it does not find a match. I tested this by manually typing the same exact value and now it finds a match.

Thank you

Please Log in or Create an account to join the conversation.

Pasted Values in Lookup don't find a match even when they look exact. 9 months 4 weeks ago #18740

Hi Tim

When you copy data from "SELECTED" Excel cell into any application, for example, notepad++ end of line is added.

Here are the pictures:




When you select the data within the cell it does not happen

Attachments:

Please Log in or Create an account to join the conversation.

Pasted Values in Lookup don't find a match even when they look exact. 9 months 4 weeks ago #18741

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7606
  • Karma: 33
  • Thank you received: 418
Hi Tim

Copying data from excel one cell at the time can be very time-consuming operation.
A better alternative is copying an entire list from excel.
(It only works when the list is empty)

Mike
Attachments:

Please Log in or Create an account to join the conversation.

Pasted Values in Lookup don't find a match even when they look exact. 9 months 4 weeks ago #18742

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7606
  • Karma: 33
  • Thank you received: 418
Or you can use the import wizard...

Mike
Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 177 guests and 3 members online