https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974551#M110628 <P>Besides what Jed already suggested, creating a Distribution with histograms only (Analyze &gt; Distribution), then add boxplots and arrange them in rows. I use it as a quick visual way to identify relationships between variables and see outliers.<BR /><BR />You can also make your steps repeatable using the workflow builder in JMP. That's in File &gt; New &gt; Workflow.</P> Thu, 01 Oct 2026 20:30:05 GMT MarilynWheatley 2026-10-01T20:30:05Z https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974006#M110613 <DIV class="flex max-w-full flex-col gap-4 [&amp;&gt;div:has([data-free-thinking-preview-answer=true])+:is(.text-message,.relative:has(&gt;.text-message))]:-mt-2 grow"> <DIV class="min-h-8 text-message relative flex w-full flex-col items-end gap-2 text-start break-words whitespace-normal outline-none keyboard-focused:focus-ring [.text-message+&amp;]:mt-1" dir="auto" tabindex="0" data-message-model-slug="gpt-5-6-t-mini" data-turn-start-message="true" data-message-id="9bb519ce-cb98-488c-acdd-f0b283b56de0" data-message-author-role="assistant"> <DIV class="flex w-full flex-col gap-1 empty:hidden"> <DIV class="fbskMG_root LR5Y_W_content markdown prose dark:prose-invert wrap-break-word w-full light markdown-new-styling"> <P data-end="284" data-start="119">I’m working with a large mortgage note portfolio and trying to create a more reliable way to identify data problems before the assets move into deeper due diligence.</P> <P data-end="619" data-start="286">The portfolio contains fields such as loan balance, payment history, interest rate, maturity date, property information, lien position, tax status, and assignment records. The challenge is that some records are incomplete, some values do not match across different files, and a few assets appear to have unusual payment or lien data.</P> <P data-end="943" data-start="621">I’m interested in using data analysis to find these exceptions automatically rather than reviewing every record manually. For example, it would be useful to identify missing values, duplicate records, unusual loan balances, inconsistent dates, or assets where the reported lien position does not match another data source.</P> <P data-end="1112" data-start="945">For those who work with JMP or similar analytics tools, what approach would you use to build a repeatable workflow for this type of mortgage note data-quality problem?</P> <P data-is-only-node="" data-is-last-node="" data-end="1267" data-start="1114">Would you use statistical outlier detection, data validation rules, visual dashboards, or another method to identify the records that need deeper review?</P> </DIV> </DIV> </DIV> </DIV> <DIV class="z-0 flex min-h-[46px] justify-start">&nbsp;</DIV> <DIV class="pointer-events-none -mb-px h-px w-full opacity-0" aria-hidden="true">&nbsp;</DIV> Tue, 29 Sep 2026 11:13:15 GMT https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974006#M110613 prash_sh 2026-09-29T11:13:15Z https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974527#M110627 <P>In the Analyze &gt; Screening Menu, the Explore Outliers and the Explore Missing Values platforms might be exactly what you're looking for. Using the Column Header Graphs is also a way to visualize missing values and outliers without needing a tool.</P> Thu, 01 Oct 2026 17:55:59 GMT https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974527#M110627 Jed_Campbell 2026-10-01T17:55:59Z https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974551#M110628 <P>Besides what Jed already suggested, creating a Distribution with histograms only (Analyze &gt; Distribution), then add boxplots and arrange them in rows. I use it as a quick visual way to identify relationships between variables and see outliers.<BR /><BR />You can also make your steps repeatable using the workflow builder in JMP. That's in File &gt; New &gt; Workflow.</P> Thu, 01 Oct 2026 20:30:05 GMT https://community.jmp.com/t5/Discussions/How-Do-You-Identify-Missing-or-Inconsistent-Data-in-a-Mortgage/m-p/974551#M110628 MarilynWheatley 2026-10-01T20:30:05Z