ETL and Data Integration tools - Modern ETL software for everyone

Hi there

I'm new to this forum. I've tried the manual and the online tutorials but can't find the answer to the following question...

I'd like to split a range of numbers into 3 "Bands"

1. If Price is less than $150 then show Sales Band A
2. If Price is between $350 and $500 then show Sales Band B
3. If Price is more than $500 then show Sales Band C

I know how to split the data using data validator my problem is that it should produce one file not three

Please help
Thanks in advance
Nau

You can use calculation like this one

if [F001]< 150 then
Result := 'Band A'
else if [F001]> 150 and [F001]< 500 then
Result := 'Band B'
else
Result := 'Band C';


Peter