Bucket with alphanumeric...

[sibideepak]

GEID	Level
155058	C14
234708	C16
257645	C15
307479	C15
430422	C15
435929	C16
815579	A05
818027	A05

in this data i want to create bucket with Level..

the range to  character ie) A will one bucket , C will be another bucket ...it should be dynamic not only for A and C..

and measure is count(GEID)...and one bar should display combined data of all.

[Anonymous]

In your load script add a line like this :

     left(Level,1)     as Bucket ,

[datanibbler]

Hii Deepak,

you can try splitting it with the LEFT() and RIGHT() functions (into C and 14 and the like) and then put both those expressions inside a DUAL() function.

That way, you'll have both the letter and the number in one field and you can sort by (or bucket by) whatever you like.

HTH

Best regards,

DataNibbler

[rubenmarin · Accepted solution]

Hi Deepak,

Not sure if I understand it well...You can use

Left(Level, 1) as Bucket

or

PurgeChar(Level, 1234567890) as Bucket