Hi
I need to know one Comparisons in CSV like this...
Could you pls help me on this issue..
These are the columns in CSV 1 and CSV 2 :
Dekking id; Dekking; Acnv_id; Acnv description; From ; To; Value
Sample From CSV 1 Data :
Columns 1
499; Algemene Contractspecificaties; 122; Periodiciteit; 15/01/16; 15/01/16; 48
Columns 2
500; Opbouw Pensioenreserve; 130; Premietaks Tak 24; 15/01/16; 15/06/32; 29
Sample From CSV 2 Data :
Columns 1
499; Algemene Contractspecificaties; 122; Commerciële; 08/01/16; 08/06/32; 12
Columns 2
500; Opbouw Pensioenreserve; 130; Waarborg 23; 08/01/16; 08/06/32; 29
I need to know how to compare these two columns from the column "Acnv description;" to "Value" as mostly the values from "Dekking id" to "Acnv_id" would be mostly common.
How to compare the values sepately FROM "Acnv description;" to "Value" Columns values IF the Columns "Dekking id; Dekking; Acnv_id;" MATCHES.
Dekking id; Dekking; Acnv_id; Acnv description; From ; To; Value
How to compare only these columns in the CSV
Pls help me on this issues pls...