Skip to Content
Oct 05, 2016 at 09:23 PM

Transformation File Mapping variable account length



I am creating a transformation file for which I have an issue with account length

The incoming txt file looks like this:

Version Account Accountkey Signeddata

Budget wer234 wer234101 10

Budget wer235 wer234102 20

Budget we235 we235104 40

In the transformation file Mapping area



AccountKey=*col(3,7:9)----------------the last three digits are the account keys


In the above example, the last three digits are recorded to the account key dimension; however due to variable length in the input file I am not able to record the last 3 digits exactly. Instead I am recording it as 101,102,04.

Any work around for this?

Further, I have to ignore '0' values in SIGNEDDATA but I am unable to do so using SKIPIF=NULL.

Is it possible to skip 0 values any other way?