Hi,
I don't think this is possible but thought I would ask anyway. I have a file that looks like this.
ID, Cashflow type, date1, date 2, amount
1234, Principal,07/12/2020, 08/12/2020, 555
1234, Interest, 08/12/2020, 09/12/2020, 666
If the Principal type with ID of 1234 has a date 1 not equal to date 2 I want Beyond compare to ignore any differences in the Interest row with it's counterpart file. So in the example above any Interest difference will be ignored.
Any idea if this is possible?
Thanks
David
I don't think this is possible but thought I would ask anyway. I have a file that looks like this.
ID, Cashflow type, date1, date 2, amount
1234, Principal,07/12/2020, 08/12/2020, 555
1234, Interest, 08/12/2020, 09/12/2020, 666
If the Principal type with ID of 1234 has a date 1 not equal to date 2 I want Beyond compare to ignore any differences in the Interest row with it's counterpart file. So in the example above any Interest difference will be ignored.
Any idea if this is possible?
Thanks
David
Comment