Forum Discussion

JPaps's avatar
JPaps
New Contributor III
5 years ago
Solved

Doing a Lookup In SnapLogic? [Help]

Hi, I have the following use-case and I haven’t found any way to get it done within SnapLogic. I am wondering if it is possible at all using this tool. I have a CSV File in Snaplogic Designer wit...
pipeline
transform
JPaps's avatar
JPaps
New Contributor III
4 years ago

Thanks everyone for your help. @bojanvelevski 's solution works. The issue I was facing was that the join was failing due to the ID’s in both files not matching.

The output document’s ID’s, derived from the CSV files were encapsulated with quotes (") where as the excel didn’t have these. Data types were both text so for example, the join was looking to match ID: 001 with ID: “001”, this would fail. Once I sorted this issue out by doing a replaceAll() function in the join snap, the solution worked flawlessly.

Thank you @ptaylor for pointing me in the right direction to check my data. In this case I triple checked it. I can’t believe that I missed that lol.

  • ptaylor's avatar
    ptaylor
    Employee
    4 years ago

    I would have expected the CSV Parser to remove those double quotes. But I’m glad you figured it out.

    • ptaylor's avatar
      ptaylor
      Employee
      4 years ago

      BTW, where/how did you put the replaceAll in the Join snap settings?