While reading one CSV file i want to lookup another CSV file for required data and that data i need to add it into my log

any one has any idea?

example ::

one.csv
sno, name, address
1,kishore,dvk
2,rajesh,hyd
3,geetha,nlg

two.csv
sno, phoneNumber
1,45678
2,59787
3,78974

output :::

1, kishore, dvk,45678
2,rajesh,hyd,59787
3,geetha,nlg,78974

This looks like a good match for a translate filter.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.