The input to a transformer contains 8 fields
ID
year
sts
mbr
year1
sts1
year2
sts2
the output should contain only 2 fields.
ID
year (OR) year1 (OR) year2
ID remains the same
and for getting the other one below conditions should be applied
if sts--Active then "year"
else if mbr--Y
then "year"
else
if sts1---Active
then"Year1"
else
if sts2-----Active
then "year2"
Is this valid in the transformer (If Then Else) condition
pls let me know!!!
Transformer condition
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Transformer condition
Regards,
Kenny
Kenny
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: