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...
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.