How to Join two csv files in Batch Scripting

November 10, 2020 at 08:26:29
Specs: Windows 10
Hi All,

I am a database developer, new to batch scripting. I have implemented the below solution in the Oracle database, but due to some constraints, I need to join the files directly.


I have two files( AM6973_20201011.csv and NIKE_22102019.csv), NIKE_22102019.csv file has some 10 columns, I want to add column 4, column6 and columns 13,15 and 18 from AM6973_20201011.csv to the NIKE_22102019.csv file. Both have a NikeKey as unique values.

My question is how can we join two .csv files in Batch scripting because I want to add columns from AM6973_20201011.csv to NIKE_22102019.csv only if the NikeKey is matching between both these files

Regards,
Sara


See More: How to Join two csv files in Batch Scripting


#1
November 10, 2020 at 12:04:43
Use the below command

mv AM6973_20201011.csv > NIKE_22102019.csv


Reply ↓  Report •

#2
November 11, 2020 at 20:59:27
It seems I'm not the only one who doesn't know what NikeKey is.

A good solution starts with a good statement of requirement.

=====================

M2


Reply ↓  Report •

#3
November 11, 2020 at 21:00:34
#1,

I'm not with you on mv

=====================

M2


Reply ↓  Report •
Related Solutions


Ask Question