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

Transformation File Mapping variable account length

36 Views

Hi,

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

Version=*col(1)

Account=*col(2)

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

signeddata=*col(4)

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?