Creating Flag?

[khadeer]

Hi,

I have one coloumn with batch codes like AB1000, AB2000, CD3000,CE4000, AB5000 like this i have so many fields in that BATCH dimension. Now i have to divide those fields as 2 different dimensions.

The batch code which starting with AB is come into one group remainining into other group......

How i can do in backend.

Regards,

Khadeer

[MayilVahanan]

HI

     Try like this,

     Load *,    if(wildmatch(BatchCode,'AB*',BatchCode) as SplitBatch from table;

Hope it helps

[#3]

this...

If (Left(Group,2) = 'AB','AB Group', 'Other') as Category