Logic Help

[apthansh]

HI ,

I need logic help on one thing..

I have data as below

Table1

BID LID

1     23

1     24

2     25

2     26

3     24

How can I get the LID count on each building

Thank s much

[vishsaggi]

What is the issue you are facing? Count(LID) does not work ? Where are you displaying this data?

[johnca]

Maybe like this?

Table1:

Load BID,

     Sum(LID) as LID_SUM

     Group By BID;

Load * Inline [ BID, LID

1, 23

1, 24

2, 25

2, 26

3, 24

];

This will results in a simple table with BID 1 = 47, BID 2 = 51 and BID 3 = 24;

BID	LID
1	47
2	51
3	24

[eduardo_dimperio]

Could you please put some output example, to better understand?

[Anil_Babu_Samineni]

I think, This will deserve.

Count(TOTAL <LID> BID)

[sasikanth]

Try this,

Sum(Total <BID> LID)

[chinnuchinni]

hi ,

try this:

load * inline [

BID, LID

1,     23

1,     24

2,     25

2,     26

3 ,    24

];

[shiveshsingh]

Can you try this?

=Sum(Total <BID> LID)

[Anil_Babu_Samineni]

I apologies guys for telling this (Because, I really not digesting for this )

My reply is May 23, 2018 11:22 PM

shiveshsingh‌ (Replied around -- 5:11 AM)

sasikanth_narne  (Replied around -- May 24, 2018 12:18 AM)

Note - If we still looking the community, Because there might be another solution (Approaches should differ) rather simply doing same expression posting then we will learn do this, Instead - If you like from some one answer is same for another you can like it

[shiveshsingh]

Hi Anil,

I thought the expression that you shared (Count(TOTAL <LID> BID)) would not give correct result, It should be Count(TOTAL <BID> LID)) to get the count of LID