topic How to 'join' two data sets but neither left join or inner join are suitable? in Splunk Search

How to 'join' two data sets but neither left join or inner join are suitable?

lewisgrantevans — Tue, 24 Sep 2019 11:20:28 GMT

Hi everyone,

I've tried to answer this myself but no luck. I fear it might be so simple i'm overlooking it. I'm comfortable with left & inner join, however i'm trying to 'join' two data sets that share the same field names but completely different values.

spreadsheet one -

'Issue key' 'Aging' 'Status'
'DR-1004'         '3'             'In Analysis'
'DR-1007'         '2'              'New'

Spreadsheet two -

'Issue key' 'Aging' 'Status'
'IT-85'       '6'             'New'
'IT-86'               '7'             'New'

And i'd like my results to be -

'Issue key' 'Aging' 'Status'
'DR-1004'         '3'              'In Analysis'
'DR-1007'         '2'              'New'
'IT-85'       '6'             'New'
'IT-86'               '7'             'New'

Which command can I use to add the results of spreadsheet two underneath the results of spreadsheet one, without using a matching field?

Please note I am using .csv files rather than indexes or sourcetypes.

Thanks!

Re: How to 'join' two data sets but neither left join or inner join are suitable?

HiroshiSatoh — Tue, 24 Sep 2019 12:54:27 GMT

Try this!

(|inputcsv spreadsheet 1)|append [|(inputcsv spreadsheet 2)]

Re: How to 'join' two data sets but neither left join or inner join are suitable?

lewisgrantevans — Tue, 24 Sep 2019 13:43:21 GMT

Thanks, Append is what I was looking for, however the above didn't work. I tweaked it slightly and now i'm getting results.

| append [inputlookup Todays-IT-Tickets.csv | search Status=New OR Status="In Analysis"]

Cheers!

Re: How to 'join' two data sets but neither left join or inner join are suitable?

jacobpevans — Tue, 24 Sep 2019 20:46:35 GMT

Please don't forget to "Mark as Answer" if your question has been resolved.