Need SubString

[us1aslam1us]

Hi Prabhu

What exactly you want to do and what does the 3rd condition do?

Sam

[rwierdsm]

praburaj,

You need an output column in your transform stage that has a derivation something along these lines:

Code: Select all

If input.expense_level [1,3] <> 'LPG' then input.expense_level else
if input.expense_level [1,3] = 'LPG' then 'NPG' : input.parent_expense_level [4,30] else  
if input.expense_level [1,3] = 'LPG' and index(input.expense_level, '*', 1) = 0 then >reject processing of your choice<

I wasn't completely clear on what you want in your second condition, but it should be something similar to what you see above.

If the Parent_expense_level is coming from your hash file as a lookup value, ensure you are setting either a constraint or a default value if the lookup fails.

Hope this helps,

Rob

[ray.wurlod]

Why me particularly?

[praburaj]

I expect all help. Plz help me. I want solve the problem.

Regards,

prabu

[us1aslam1us]

Hi Prabhu

I think you can join condition 2 and 3 and use Robs code like this:

Code: Select all

If input.expense_level [1,3] <> 'LPG' then input.expense_level else 
if input.expense_level [1,3] = 'LPG' and index(input.expense_level, '*', 1) = 1 then 'NPG' : input.parent_expense_level [4,30] else  
<reject or error>

IHTH
Sam

[DSguru2B]

Why me particularly?

Because your everyone's favourite

Actually you need to put the codes advised by our fellow forum users in a stage variable and for the last value specify a default value like say 'R'.
In the constraint of your target you need to specify
stgvar <> 'R'
and in the constraint for the reject file specify
stgvar = 'R'.

[sb_akarmarkar]

Code: Select all

If input.expense_level [1,3] <> 'LPG' then input.expense_level else 
if input.expense_level [1,3] = 'LPG' and index(input.expense_level, '*', 1) = 1 then 'NPG' : input.parent_expense_level ['*',1,1] else  
<reject or error> 

little change , Try this

Thanks,
Anupam