AnsweredAssumed Answered

Is there a way we can join 2 tables in DB through Boomi and fetch the details from those 2 tables using primary key?

Question asked by anusha.boddapati217788 on Nov 30, 2017
Latest reply on Nov 30, 2017 by Adam Arrowsmith

Is there a way we can join 2 tables in DB through Boomi and fetch the details from those 2 tables using primary key?

I have first table 'a' with columns number, name and address and second table 'b' with columns number, designation,salary.

I need to join table 1 with table 2 with condition a.number=b.number.

and fetch the data which is coming common in both tables.

But I tried executing the process. I got following error:

 Embedded message: SQL Errors occurred while processing retrieved data: Conversion failed when converting from a character string to uniqueidentifier.; Caused by: Conversion failed when converting from a character string to uniqueidentifier.

Outcomes