logic help

[abhaysingh]

Hi,

I have scenario in which i have data like below

Field1      Value

asd-11    10

qwe-12    11

edc-43    12

Repeat    8

asd-11    11

qwe-12    12

qwe-13    11

You can see in this, asd-11 having two rows , by default if we put this in bar chart it will agrregate, so to overcome this and show it differently i used

dual( Field1, RowNo()) as Field1 and its working but issue is in this you can see one row is value Repeat, i m loosing that row

please suggest how i can get it?

[Saravanan_Desingh]

I'm not sure, if I understand.

I tried the same and I didn't get missing anything. Please check the attachment.

[amayuresh]

It is working fine for me

I used below script:

t1:

LOAD * INLINE [

    Field1, Value

    asd-11, 10

    qwe-12, 11

    edc-43, 12

    Repeat, 8

    asd-11, 11

    qwe-12, 12

    qwe-13, 11

];

NoConcatenate

t2:

Load dual( Field1, RowNo()) as Field1,Value Resident t1;

Drop Table t1;

Bar chart with Dimention Field1 and expression as sum(Value)