Service Desk Practitioners Forum
cancel

DATA EXCHANGE - UNION of 2 files

Highlighted
Bertels
Trusted Contributor.

DATA EXCHANGE - UNION of 2 files

hi all,

i want to use data exchange to insert ci's in the cmdb..

i am using the jstels free csv driver,
does anyone know how i can do a union with 2 files???

Greetings

S.
1 REPLY
Jonathon Druce
Acclaimed Contributor.

Re: DATA EXCHANGE - UNION of 2 files

I am not sure if you can do it with the csv driver but with a sql connection you specify 2 sources and then join them using the condition statement;

SOURCE=[file1], [file2]
ATT=[field]
COLUMNS=[file1].[attrib] AS [field]
CONDITION=[file1].[linkattr] = [file2].[linkattrib]

This will produce an inner join - outer joins are more tricky.