IF([Sales_Rank] < 26, 'Top 25', IF ([Sales_Rank] < 51, '26-50', IF ([Sales_Rank] < 101, '51-100', IF ([Sales_Rank] < 201, '101-200', '200+'))))
the above expression giving the correct output with respect to Rank and bucket. but, want to learn to write in load script. below script for reference.
please help.
LOAD
[ID], [ClientName], [Client Type], [Region HQ], [Country HQ], [Region], Product, Period, Sales, Revenue, SoW, Comments, Status, GMAssetClass, TIER_NAME FROM [CData.csv] (txt, codepage is 1252, embedded labels, delimiter is '|', msq);