how to create a custom query in datamapper

OL Connect Professional DataMapper
1

I see you can create custom queries in the datamapper for ODBC data sources, so I’d like to be able to use data from two different Excel worksheets.

I’d like to be able to create a join from one sheet to the other using a key field called “segment”. I’ve tried:

SELECT * FROM ‘sheet1$’ a LEFT JOIN ’ Sheet2$’ b ON a.Segment = b.Segment

but no luck, this doesn’t work. Can anyone explain how to do this, assuming it can be done?

thanks!

2

Hello Lou,

Can you provide an example spreadsheet? I’d like to try it on my side, this should work. If it contains any client data, send it to my email, lachancee@ca.objectiflune.com .