Forum Discussion

sdeng's avatar
sdeng
New Contributor II
7 years ago

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.

1 Reply

  • Nidam's avatar
    Nidam
    New Contributor

    Hi,

    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!