R script needed to mimic excel's index+match+match
Budget: $30 – $250 USD
See image: The task is to compare records in the table below in one source (file A) against another source (file B) and see if they are equal.
-To be more specific, we might want to check the sex of policy ID number X in file A against the sex of policy ID number X in file B and see if they are equal. This task is like a lookup in excel using index+match+match. But this cannot be done in excel because the actual file is very large (100MB+) and difficult to open.
-The names of the column/fields headings may be different between file A and file B.
-Only 20 out of about 100+ columns/fields need to be checked. All 100,000+ policy IDs need to be checked.
-The input files, files A and file B will be .txt files. Each row contains all 100+ columns/fields as follows: Each column/field (including policy ID) is contained in 64 characters. So field 1 (Policy ID) is the first 64 characters, field 2 is characters 67-128, field 3 is characters 129-192 and so on. Each field includes white spaces to get to 64 characters.
I hope this is about an hour of work and I will pay USD$30. We can discuss further.
-To be more specific, we might want to check the sex of policy ID number X in file A against the sex of policy ID number X in file B and see if they are equal. This task is like a lookup in excel using index+match+match. But this cannot be done in excel because the actual file is very large (100MB+) and difficult to open.
-The names of the column/fields headings may be different between file A and file B.
-Only 20 out of about 100+ columns/fields need to be checked. All 100,000+ policy IDs need to be checked.
-The input files, files A and file B will be .txt files. Each row contains all 100+ columns/fields as follows: Each column/field (including policy ID) is contained in 64 characters. So field 1 (Policy ID) is the first 64 characters, field 2 is characters 67-128, field 3 is characters 129-192 and so on. Each field includes white spaces to get to 64 characters.
I hope this is about an hour of work and I will pay USD$30. We can discuss further.