Hi all-- See my customer's question below. I can do this in a series of manual steps and save as a script, but hoping to find a simple way to do it. Almost seems like an odd format we might see in one of the Reliability platforms (like Nevada format)...
Customer says:
I wonder if you have a suggestion for this particular problem I’m facing. I have a lot of data on inventory of parts, like what’s shown below. The data represents the amount of material on-hand by Year and by Pe (month). I need to create plots and tables showing how much inventory we had at a particular time. At first glance, you’d think all I would need is a data filter for year and month and we’re done. The problem is that the way the data is stored, it only enters a value for months when a change occurred. If nothing changed, then there’s no entry and the data filter method will use zero for the value (because there isn’t one).
For example, look at the second “material description” below. In 2016 month 3, there was $6,186 in inventory. There are no other entries until month 10, where it increases to $6,284. If I ask JMP for the inventory in month 7, for example, it will say zero, but I need it to say $6,186 because that was the last reported value at the time.
Do you have any ideas how I could use JMP with this data to return an accurate summation of inventory given this constraint?
Thank you Brady! Excellent suggestions that should help my customer. I owe you (yet again!).
Jerry
Hi Jerry,
I don't have an easy way to do this, but there are some tools (both built-in and via add-in) that lessen the pain. With some practice, getting the data into a nice form should only take 2-3 minutes. I am not sure whether that's acceptable to your customer, but a flexible and robust scripted solution to cover any generic problem of this type (i.e., not just solving the problem for this specific combination of columns) would be somewhat involved.
Take a look at the attached video (under 3 minutes), perhaps this flow would work for your customer.
The Data Table Tools addin can be found at the link below.
https://community.jmp.com/t5/JMP-Add-Ins/Data-Table-Tools-Add-in/ta-p/28582
<script>LITHIUM.OoyalaPlayer.addVideo('https:\/\/player.ooyala.com\/static\/v4\/production\/', 'lia-vid-dtNTNzZTE6D9LiW2I4JDa65l6XX0wUv0w320h200r996', 'dtNTNzZTE6D9LiW2I4JDa65l6XX0wUv0', {"pcode":"ltbGkyOjMl3V3pZ3Trn6T2z1_rjF","playerBrandingId":"ODI0MmQ3NjNhYWVjODliZTgzY2ZkMDdi","width":"320px","height":"200px"});(view in My Videos)
