Picking up the Right values n loading to DW

[amitendra_amit]

Hi All,

The Scenario is like the one given below......


OCI----->Transformer----->SQFS
....................^
.....................|
.....................|
.................Hash File ((( Hash File pointing to the transformer))))

Definition Of Metadata
--------------------------
OCI | Hash File | SQFS
----- ----------- ------
TR1(VarChar) | NUM(Might be 1,2,3) | d1---(Value=TR(NUM))
TR2(VarChar) |
TR3(VarChar) |
------------------------------------------------------------------------------------

Depending on the value returned from the Hash file .....

Say for Example NUM=2 ....Then Value in TR2 Should be returned to d1......

I can use the If...Then ....Else .....like

If (NUM=1) Then TR1...ElseIf(NUM=2)..... like that...
Actually there are TR1,TR2,TR3.......TR30...
So the If..Else...Then will be very long.....

Is There any other way through which i can work it out...


Please do suggest me other options....

Thank You,


Cheers!!!
AMit

[DSguru2B]

Write a routine and use a Case statement maybe

[ray.wurlod]

Code: Select all

Field("TR1|TR2|...|TR30", "|", TheNumber, 1)