Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

DATA EXCHANGE - UNION of 2 files

Highlighted
Bertels
Super Collector

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
Honored 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.
//Add this to "OnDomLoad" event