Merging of two csv files

Hi,

I have 2 big excel (csv files) of columns & rows ..The values contain diffent type of groups. For example, 1 to 10 rows belongs to one ID and then 11 to 14 rows belongs to another catogery of ID and so on ... I have 60 thousands of catogiries with several number of rows & columns.

From 1st Big excelfile ( CSV file): I need to collect the data of one ID programmically and put this data into small excel sheet

From 2nd Big file excelfile ( csv file) : I need to collect the data of one ID programmically and put this data into small excel sheet.

Now: I have 2 small excelsheets.

I need to combine them.

THIS PROCESS SHOULD BE CARRIED OUT FOR EVERY INDIVIDUAL ID.

I request you to somebody could provide the thoughts and incase of example code to discuss on.

Your suggistions would be highly valuable and welcome.

Answer 1

[KSSV]

Read about readtable and join