skip differences less than certain thresholds

[tedsung]

We typically compare data in files whose values can change by a penny.
Is there a way that BC4 can compare numeric values to within
a set threshold?

Thanks,

Ted

[Aaron]

Hello,

Which compare session type are you currently using? The Table Compare does support a Numeric Tolerance for a Numeric column (Data Compare, Session Settings, Columns tab, select specific column, then uncheck Use default).

This requires your data to be parsable in the Table Compare, and preferably with a Key column(s).

[tedsung]

I see that. My text files can be loaded in using Table Compare.

Is there way I can specify this type of compare be done on my 2 files and also
specify the numeric tolerance from the command line or a script?

[tedsung]

command line load using table compare

I just wanted to see if this question was still in the queue for a response.
Thanks,
Ted

[Aaron]

Sorry for the delay.

The best way is to use the File Formats dialog and create a new Table format for your file extension. This would then be used (if the topmost match), which determines the session type opened automatically for those files.

Otherwise, what would be your final goal of an automated solution? Generate a report from script? You could use the data-report command and pass in two file names, which would use the default Session Settings (set on the Home screen in the saved Sessions list, Edit folder, select Table Compare).