Compare .CSV file

Does this comparison have to be done in Appian? Also are you doing this more than once or is this a one time effort followed up by a one-time data import? If this is a one time effort and you do not need to do it in Appian, you could use the Windows command line to run the following command:

fc filename1.csv filename2.csv > outfile.txt

Source: stackoverflow.com/.../33523588

If you need a more repeatable solution, you'll probably have to develop your own plugin. I don't think the implementation would be too terribly difficult in Java. It could be memory intensive based on your dataset though.

Does this comparison have to be done in Appian? Also are you doing this more than once or is this a one time effort followed up by a one-time data import? If this is a one time effort and you do not need to do it in Appian, you could use the Windows command line to run the following command:

fc filename1.csv filename2.csv > outfile.txt

Source: stackoverflow.com/.../33523588

If you need a more repeatable solution, you'll probably have to develop your own plugin. I don't think the implementation would be too terribly difficult in Java. It could be memory intensive based on your dataset though.