I have two tables, [Main Data] and [Drug List] which are linked via a field [Drug Code]. I have the following information for the two tables:
[Main Data] - [Drug Code] has an information density of 99.45% and a subset ratio of 61%
[Drug File] - [Drug Code] has an information density of 100% and a subset ratio of 61%
i seem to be losing a lot of information within this link as the [Drug File] gives a lot of null values. What could be happening?
To understand what the problem is, load [Drug Code] from [Main Data] table give it a name and QUALIFY this new table and do same for [Drug Code] from Drug file table give it a name and QUALIFY this table.
Then in UI put list box for each [Drug Code] from this new tables you've just created and SEND TO EXCEL. Analyzing the excel file should tell the story.
My guess is there are Drug Codes not matching hence the NULL value.