DSXchange

Hello Friends

I have a requirement where if either of values are present then i need to put a particular value in other column.This can be done using a IF-ELSE statement but the problem here is a lot of values to be checked. For ex

If column A IN ('A','B','C'......15 values) then Column B='Value'

Any simpler way to implement this.

Thanks in advance

Regards
Ulhas

Search DSXchange for solutions using the Index() function.

Ray,

This can be achived by using the mix of 'looping' capacicty of transformer and index() function.

Is this what you have intended/hinted?


Regards,
Raja R P

No need for looping. Use Index() or a Lookup stage.

As noted, you don't need a loop. A single Index() function can check all possible values. Delimit them, and the search string, with some character (space will do). For example, the following function will return 0 if not found and some non-zero value if found.

Thanks All

I used Index() function and it worked

Regards
Ulhas