Error in Following script !!

[nikhilgarg]

Hello,

Something going wrong in my following script. Please tell me where it is wrong.

Data1:

LOAD Months,

     Value,

     MissingCount(Item) as CountOfMissingItem

FROM

(ooxml, embedded labels, table is Sheet1) Group By Months ;

------------------------------------------------------------------------------------------------------------------

Months and Item are Characters and Value are Numeric.  In Item field i have put some values empty.

Thanks

[nikhilgarg]

Hey,

I have attach the application sample. Please check it out and kindly tell me how the output of MissingCount Working here.

Thanks

[tresesco]

This could have been explained the way you want in a class-room training. But here, it would be a bit lenghty, better you narrow down your issue. I would suggest to explain the specific doubt.

[nikhilgarg]

Hey,

According to me ,

Under CountOfMissingItem field, it should show 0 in place where item is missing and 1 in place where item is not missing. But the output is somehow random. Can you explain it now ??

[tresesco · Accepted solution]

The source table you have:

And you are counting missing value for Item(and not Value) field and they are missing at position for Months Mar and Apr. It is fine, I see.

[nikhilgarg]

HEy,

Thanks i got it where i was wrong. I was actually seeing the value instead of item.

Thanks

[tresesco]

Dear Nikhil,

It's a good idea to close the thread by properly marking answer helpfui/rigth answer, it makes other people know that the question/thread is answered and might not require further clarification to it.