Hi there,
I'm having some difficulty identifying and taking actions on features where no entries are passed. Here's what my data looks like:
TYPEGEOCLASSRESTRICTIONSIGNMissing4132Incorrect3361Rework2345Problem is, my output is an excel sheet that uses a precise template, and I need all records to be present, regardless of their values. I will be running several datasets through the workspace, all with different values missing and/or present.
So if I run data through the workspace and there are no entries that has TYPE = Rework, the output looks like this:
TYPEGEOCLASSRESTRICTIONSIGNMissing4132Incorrect3361What I need instead is:
TYPEGEOCLASSRESTRICTIONSIGNMissing4132Incorrect3361Rework0000So what I essentially need is to just have a test for each TYPE (Missing, Incorrect, Rework) and if there are no entries, I pretty much just need to create a blank entry (0, or _, or whatever) with the same TYPE name.
Am I overthinking this or missing the obvious?
Thanks in advance,
Best answer by takashi
View original