Our front office has this glorious software that takes all our data via CSV and shuffles it around and makes us 95% more efficient
Honestly, maybe it helps, but their dimensional software analysis tools require perfect data formatting from us. Not something I'd like to be dependent on.
Today, I was made aware that a new part is transmitting CSV data that is missing a column titled 'Segment'. I guess all our programs export this column, but this new part isn't playing nicely. Our head programmer exhausted all his knowledge working on this today, some of his workarounds were actually quite ingenious listening to them.
I'm not asking for anyone to think too hard about this, but is this something you know about and why this SEGMENT column even exists and why it would randomly just disappear?
The top pic below is our normal working export data with the SEGMENT column, our front office loves the SEGMENT column...and the below is the problem child, without it we are shutting down for the next 2 years I think.
So I went from 'Overwrite' to Auto Index and now it correctly is kicking out a proper csv file, but it also kicks out a completely empty one. Weird, anyway, this should fix our problem I think.
So I went from 'Overwrite' to Auto Index and now it correctly is kicking out a proper csv file, but it also kicks out a completely empty one. Weird, anyway, this should fix our problem I think.