Excluding Zero from Import

[Former Member]

Hi,

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?

Kind Regards,

Fiona

[sorin_radulescu]

You can us the transformation file and the instructions SKIPIF.

for more details use the online help from DM module (webexcel module).

Regards

Sorin Radulescu

[i045436]

Fiona,

You can add a step to the Import package which is filtering the zero values before go to the convert task. For example you can load the file into a temporary SQL table, delete the records with 0 values and export then to a new file which will pass to the Import.

Regards,

Mihaela