I am trying to compare values between two excel files in talend but not too sure how to do it.
I need to compare if the total number of records in file A is equal to a cell with the sum value in file B. Based on this result i need to run a job to insert records into Salesforce.
Does anyone have an idea how the comparison between 2 data files can be done?
Read all records from file A with tFileExcelInput component, then use tAggregate to count the number of rows. Send the number of rows into a tMap. On your tMap, lookup the value in file B. Compare the 2. And then carry on from there.
There is a possibility here to use data preparation, and recipes in Data Prep. But it will depend on your data and what your logic is.
Refer attached job which will do what you are expecting.
1) Below flow is just for logging
2) Change tlog (matched) with your salesforce output to write into salesforce
I tried using @sjain's flow. however im having trouble with the tMap.
I need to count the number of rows in a particular column of inputExcel1 and check if it matches the value of in a particular cell (B3) in inputExcel2.
Any idea how the mapping/expression can be defined?