Related records / set analysis

[#1]

I frankly have no idea where to start with this, but in the past the brilliant minds at the community have helped me out, so here is where I turn.

(Obligatory but heart-felt flattery always works, right?  )

I have a table that has a reference to a separate record in the same table. In this case, the reference is to a prior record that is associated for some reason. (All this is handled in the SQL behind the scenes)

For example

ID	Data Fields...	RelatedID
1001	Lots of data here for 1001	-
1002	Lots of data here for 1002	-
1003	Lots of data here for 1003	1001
1004	Lots of data here for 1004	-

So, I know that ID 1001 and 1003 are related, but the only way I know is because RelatedID contains a value.

I wish to compare the Datafields from 1001 with the Date fields from 1003, but I don't know how. Assume that I restrict my selections to 1003, how do I use the values of this table to get at the different data fields?

I suspect that set analysis may be involved, but I'm at a loss as to how to proceed. Anybody done something like this and can point me towards a solution? Thanks in advance for any assistance.

[Anonymous]

Rob

How about loading the data twice, first a plain simple load.

The for the second load:

• Assign a different QV table name than the first loaded table name
• Rename [Related ID] to ID
• Rename all the other required fields with a suffix of say Related

These 2 resulting tables should then join on ID and from then on it should be possible to do what you are after in the dashboard or maybe more scripting.

Best Regards,     Bill