Excel Data Incorrectly Suppressing
I am trying to load stage data via Excel and having an issue I am not sure how to fix. I am loading data, including for attribute values 1 and 2 (AV1# and AV2#). However, if there is a zero in eith...
Forum Discussion
MarcusH​ thank for responding. I am not using "AMT.ZS#" but only "AV1#", "AV2#" etc. Based on your comment this makes me suspect something else is causing the suppression. In either case, I think your two options above represent my two options. I think I am going to try using a transformation rule and see if I can make that work as I do not anticipate loading a lot of zeros so the incremental cost will just be the evaluation of all the rows. As long as the performance is not too bad for a typical use case I think that may be my approach. Appreciate your help.