Compare data from two files

ashmitp869 — Tue, 11 May 2021 02:51:29 GMT

Hi there,

How to find the data percentage matching from the below dataset.

The fields are [049Episode.VISIT_ID] with EP.Stay Number

Will the formula work to see how many percentage data is present

Count([049Episode.VISIT_ID])/Count([EP.Stay Number])

Re: Compare data from two files

Dalton_Ruer — Tue, 11 May 2021 13:30:06 GMT

Without worrying about whether your second file has a bunch of stay numbers that might not be in your first file, and without worrying about whether you have multiple rows for a stay/visit, then yes your formula would yield the percentage of stay numbers that have a visit id associated. 2/13

I always advise creating a quick sanity check with just the numerator and just the denominator as KPI's to check if any of the things I said "I won't worry about" are things YOU do need to worry about. If you find that the numbers don't match what you expect, you may need Count(DISTINCT or you may need to change how you load your second table to use a WHERE EXIST ([EP.Stay Number]) so that it only loads visits for stays you already have loaded.

topic Compare data from two files in App Development

Compare data from two files

Re: Compare data from two files