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 either AV1 or AV2 the row is suppressed, even if there is a non-zero value in the other attribute dimension. Is there a way around this behavior with a special token I can add or some other change?
I am assuming you are using AMT.ZS# in the source Excel on all the amount columns. You could handle by not suppressing zero for the import and then use Transformation Rules to Bypass any source records with a zero Amount. It's not nice as you get a lot of zero records loading.
Alternatively you can create a named range for each amount column i.e. the amount and attribute value columns are all flagged with AMT.ZS#. The trick is to start the named range on separate lines. Something like this:
Then start one named range on row 11, another on row 12 and another row 13. You keep the same column structure as you have currently. The import function cycles through all the named ranges that begin with XFD. Each amount you have is then processed separately.
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.
