Only showing the ID selected and not those linked

[nickmarlborough]

Hi, 

I have a data set of IDs and they are linked to each other in a variety of ways creating a fairly complex spiders web of connections. 

In a table that shows the number IDs with an outstanding parking ticket, i want another table which shows every ID and all associated tickets, to only have those IDs show that have a parking ticket not those and the IDs that the parking tickets may also be linked to.

Hope this makes sense,

[Qrishna]

You could do a resident load from the table that has fields master id, parkingticket and Qualify the table or vice versa. Something like below:

data:
Load * Inline [
ID, ParkingTicket,Status
123,A123,Active
123,B123,Paid
123,C123,Paid
345,A123,Active
345,B123,Active
678,A123,Paid
];

QUALIFY*;
d1:
load *
resident data
where Status = 'Active';

As you know we can get more clearer idea when we see the code/table structure or sample date wih required output.

[nickmarlborough]

so its more a question of.....

Example:

ID	Outstanding Driving Test
1	6
2	2

ID	People within ID
1	Jeremy, Nick, Lucy
2	Nick, Sophie

so essentially what is happening is if i select the 6 (to select the ID 1) the overall count of ID that shows is 2 because as you can see in the second table 'Nick' belongs to ID 1 and 2 so therefore the link pulls in ID 2 as part of the count whereas i just want to have ID 1 and those falling to the 'count: 6 outstanding tests'

[Qrishna]

if you linke both tables on 'ID', you will always see ID=1 corresponding rows when ID=1 row is clicked in table 1:

 

can you please the some sample data set and table structure in your DM?