I have an import file that is in the format of Account Number, Value, Legal Entity, Time. I currently have an issue that the file that I'm receiving from the client has a lot of records with zero values in them. Most of these records are account codes that should no longer be imported into the system and are raising warnings when running the import. This makes it difficult to identify valid import issues from the invalid accounts. In the interim I have filtered the zeros from the csv file and stored it prior to the upload however in the live environment there will be hundreds of these files for which the client would like us to ignore these zeros during the import so that we are only left with warnings for accounts with values in them during the import.
I have tried linking the signeddata dimension to a conversion file and mapping 0 to a blank row (Null), however this has not had the result I was hoping for - any ideas?