The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sweez's avatar
Sweez
Contributor
1 year ago

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...
Data Integration
Sweez's avatar
Sweez
Contributor
1 year ago

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.