How to use fields from two csv files in a search for an arithmetic calculation to create a new field?

[karthikTIL]

HI,

I have two files, test1.csv and test2.csv.
I want to do some arithmetic calculation involving fields from both files test1.csv and test2.csv.
Also, i want to use only september month data from test1.csv.Please let me know how to involve both files in a single query to cter to my requirement.

test1.csv has fields ->name,start time,end time,total_time,date_month
test2.csv has fields->name,No_of_Person,lost_time

What i require is, if date_month=september from test1.csv and 'name' from test1.csv ='name' from test2.csv,then A=total_time*No_of_Person*lost_time, where 'A' is a new field i want to create.

[Ayn]

How about

| inputlookup test1.csv | search date_month="september" | join name [inputlookup test2.csv] | eval A=total_time*No_of_Person*lost_time

[Ayn]

Please add more information - exactly what kind of calculations, and what your csv files look like.

[karthikTIL]

test1.csv has fields ->name,start time,end time,total_time,date_month
test2.csv has fields->name,No_of_Person,lost_time

What i require is, if date_month=september from test1.csv and 'name' from test1.csv ='name' from test2.csv,then A=total_time*No_of_Person*lost_time, where 'A' is a new field i want to create.