In Memory lookup for csv files

We have two source csv files, but when using In-Memory Lookup, it won’t work. Can any one help with it?

source file:

lookup file:

lookup property:

It should use $[‘Phone Device’] to do lookup for refercence id value, but it will got below output.


Long time ago, I encountered this also.
If I remember well, it was due to the space in the right path header name.
I don’t remember if you also should remove the space in the left path header but you may want to remove it also.

You should use a mapper for each of your csv file and rename this two columns.

Give it a try and let us know!