Mapping the field which has Range of Values to the target

[former_member217874]

Hello All,

I was not able to keep a proper headline to this ..but the problem goes down here..

I have '2 fields' which have "Range of Account Numbers" and another field which is the description of those fields..Refer the screen hot below.

My Requirement is to map the above "TXT45" field to another table which contains the list of all Account numbers with respect to the above field range.

EX : If VONKT : BISKT 

          60315      60580    then my TXT45 field should map with all the Acc Number between the 60315 to 60580.

So ,If anyone could suggest me a way it would be a great help.

Regards,

Srinivas.

[former_member187605 · Accepted solution]

1/. Define two global variables: $RowNumberStartsAt and $RowCount. Initialize them in a script, using sql built-in function.

• select min(VONKT) from table
• select max(BISKT) - min(VONKT) + 1 from table

2/. Build a data flow with two sources:

• your table
• a Row_Generation transform, using both global variables for Row number starts at and Row count options.

3/. Join both sources with condition

     ROWNUM >= VONKT and ROWNUM <= BISKT

4/. Add your target table with columns ROWNUM and TXT45. Run your job.

[former_member217874 · Accepted solution]

Hello Dirk Venken ,

Using approach is working fine.

Thanks for you response.

Regards;

Srinivas