# Conditional Split to give flag ranks using percentages

### Question

•  10=500% greater; 9=400%; 8=300%; 7=200%;  6=250%; 5=150%,  I have to assign ranks in a column using the percentage data using conditional split and derived column transformation in ssis.
Wednesday, February 12, 2014 10:25 PM

• Its pretty easy. Follow these steps:

1. The source from which values 10,9,8,7... are coming add a conditional split below that.
2. Create 6 conditions using the attribute which contains these values, for example <Profit_Rank>
3. The conditions would go like this : Profit_Rank==10, Name it as Ten(or whatever suits you).
4. Now similarly create other 5 conditions.
6. Add the derived column as required. Name it as your need suffice. In this case I would say <Profit_Percent>

Thursday, February 13, 2014 5:15 AM

### All replies

• From the little I know yet about SSIS (I started using it yesterday) I would do the Derived column with a condition like this one:

YourTestColumn = 10 ? 500% : 0

something like that nested for all your values and then the conditional split.

Also, your question is hard to read and I think that's why nobody spend any time to respond your question.

I hope my answer helps you to get the desired result

Wednesday, February 12, 2014 11:41 PM
• Its pretty easy. Follow these steps:

1. The source from which values 10,9,8,7... are coming add a conditional split below that.
2. Create 6 conditions using the attribute which contains these values, for example <Profit_Rank>
3. The conditions would go like this : Profit_Rank==10, Name it as Ten(or whatever suits you).
4. Now similarly create other 5 conditions.