topic Re: How can I combine two CSV files? in Getting Data In

How can I combine two CSV files?

Sagar0511 — Mon, 23 Oct 2017 09:19:05 GMT

Hi Everyone,

I want to combine data from two .csv files which are "CBIG-SIN Updated" and "Hostnames Files" files names and the output should be displayed in one file with relevant information of each file. In both the files the Header names are different.
I have tried the commands such as inputlookup, inputcsv and then the append with the next file. But none of them are working.

Re: How can I combine two CSV files?

koshyk — Mon, 23 Oct 2017 09:25:09 GMT

can you post sample data of both the files and final sample output you require? We have no clue what you mean by CBIG_SIN until there is some sample data.

Re: How can I combine two CSV files?

niketn — Mon, 23 Oct 2017 09:25:31 GMT

@Sagar0511, can you give what are the field names in the two CSV and how do you want the output with sample mock data in tabular format?

Re: How can I combine two CSV files?

Sagar0511 — Mon, 23 Oct 2017 10:06:49 GMT

Header of file1: Date Time Interface Origin Type Action Service Source Port Source Destination Protocol Rule Rule Name Current Rule Number User Information Product Source Machine Name Source User Name

Header of file2: Name Type Location FW1 IP-Address Netmask NAT-Address NAT-Type Members Comment

In the result/Output I want both the result combining of File1 and File2. So it will be easy to search the hostnames/IP's

CBIG_SIN is the CSV file name.

Re: How can I combine two CSV files?

Sagar0511 — Mon, 23 Oct 2017 10:06:59 GMT

Header of file2: Name Type Location FW1 IP-Address Netmask NAT-Address NAT-Type Members Comment

In the result/Output I want both the result combining of File1 and File2. So it will be easy to search the hostnames/IP's

CBIG_SIN is the CSV file name.

Re: How can I combine two CSV files?

Sagar0511 — Tue, 24 Oct 2017 09:30:09 GMT

Please suggest

Re: How can I combine two CSV files?

Sagar0511 — Tue, 29 Sep 2020 16:28:11 GMT

Please find the below same Header and data for both the files

Header and data of first csv file

Number-Date-Time-Interface-Origin-Type-Action-Service-Source Port-Source-Destination-Protocol-Rule-Rule Name-Current Rule Number-User-Information-Product-SourceMachineName-Source User Name

1-16-Oct-17-23:58:58-eth2-xxxx-Log-Drop-xxxx-38611-hostxx.xx.xx.xx.static.arubacloud.de-xx.xx.xxx.xxx udp-26-26CBIG-SIN-Consolidation-NA-NA-Security Gateway/Management-NA-NA

2-16-Oct-17-23:59:00-eth1-xxxx-Log-Accep-xxxx-62006-Host_xx.xx.xx.xx.-SINDSITNCDB03AV_xx.xxx.xxx.xxx tcp-271- 271-CBIG-SIN-Consolidation-NA-inzone Internal outzone Externalservice_id: TCP_135-Security Gateway/Management-NA-NA

Header and Data of second csv file

Nr-Name-Type-Location-FW1-IP-Netmask-NATAddress-NATType-Members-Comment

1 Attack_IP_xx.x.xx.xxx host-NA-NA-xx.x.xx.xxx-NA-NA-NA-NA-NA

2 xx.xx.xx.xxx group-NA-NA-NA-NA-NA-NA-Net_xx.xx.x.x Net_xx.xx.x.x-x-NA

3 UFTP_xx.xx.xx.xxx host-NA-NA-xx.xx.xx.xxx-NA-NA-NA-NA-NA