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

[Anonymous]

Hi Ansh,

If you are using the logic in back end then use the following script,

Table1:

Load * Inline [ BID, LID

1, 23

1, 24

2, 25

2, 26

3, 24

];

Table:

LOAD

BID,

Count(LID) as [LID COUNT]

Resident Table1

Group by

BID;

drop table Table1;

and if you are using the logic in Front end then normal count(LID) will work in chart or table.

[vishalarote]

Try This,

t1:

load * inline[

BID ,LID

1,23

1,24

2,25

2,26

3,24

];

load BID,

count(LID) as Count

Resident t1

group by BID;