This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Doing a Lookup In SnapLogic? [Help]

Go to solution
JPaps
New Contributor III

‎10-13-2021 01:47 PM

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 with the following fields (example) $ID, $Name, $AmountPaid1, $AmountPaid2.

I also have an Excel File with the following fields: $ID, $AmountPaid2.

I want to alter the original CSV file by “looking up” the excel file and replacing the value of $AmountPaid2 (in the CSV) with the value of $AmountPaid2 from the excel file, only where $ID from the excel = $ID from the CSV.

Any suggestions?

0 Kudos
Reply
1 ACCEPTED SOLUTION

Go to solution
bojanvelevski
Valued Contributor

‎10-13-2021 10:19 PM

Hi @JPaps,

Yes, developing this logic in SL is very much possible. I am attaching a sample pipeline which does exactly what you need:

Lookup_2021_10_14.slp (8.9 KB)

Regards,
Bojan

View solution in original post

Lookup_2021_10_14.slp
Reply
16 REPLIES 16

Go to solution
ptaylor
Employee
Employee
In response to JPaps

‎11-03-2021 11:27 AM

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

0 Kudos
Reply

Go to solution
ptaylor
Employee
Employee
In response to ptaylor

‎11-03-2021 11:29 AM

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

0 Kudos
Reply