Missing or null data points count dynamically.

Question

Missing or null data points count dynamically.

anbillava

Ten Centuries

Points: 1146
More actions
July 22, 2009 at 9:01 am

#132113

I have a problem. I need to check missing data varables in different tables dynamically.
Variables position in each table are fixed.
For e.g
1. Table1
idtable1 a1 a2 a3 valid
2. Table2
idtable2 b1 b2 b3 valid
2. Tablen
idtablen n1 n2 n3 valid
Now i need to give a report to user like this
TableName missingdatapoints count
Table1 a1,a3 2
Table2 b1 1
. . .
. . .
. . .
. . .
TableN n2,n3 2
Is it possible .. pls let me know..
Thanks in advance...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

The Dixie Flatline SSC Guru Points: 53353 More actions · Answer 1

Could you please supply a few rows of sample data for each table, and the expected results. It would allow the people trying to help you to test any code before suggesting it to you.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 2

also, please try to write a query, or show us some effort. We don't want to do your work or answer your homework. We can help, but you need to make an effort.

A few hints, a NOT IN, or an outer join might help, but I'm not sure what you mean by missing data.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

anbillava Ten Centuries Points: 1146 More actions · Answer 3

Table1

idtable1 a1 a2 a3 valid

----------------------------------------------

1 null val null Y

2 val val null Y

Table2

idtable1 b1 b2 b3 valid

------------------------------------------------

1 null val null Y

2 val null null Y

TableN

idtableN N1 N2 N3 valid

------------------------------------------------

1 null val null Y

2 null null null

Now i need to give a report to user like this

Now the result is

TableName rownumber missingdatapoints count

Table1 1 a1,a3 2

Table1 2 a3 1

Table2 1 b1,b3 2

Table2 2 b2,b3 2

. . .

TableN 1 n2,n3 2

TableN 2 n1,n2,n3 3

Is that sufficient..

Please let me know..

Thank you very much for the reply.

anbillava Ten Centuries Points: 1146 More actions · Answer 4

Currently i am solving it through some other means.. but its taking nearly 3 hours to execute..

So i thought of getting some suggestions here....

I need to find a different approach for this now.

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 5

How are you solving it? And what are you solving?

You need to give a bit more detail about how you want to transform the tables into other data, and show us an attempt.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

anbillava Ten Centuries Points: 1146 More actions · Answer 6

I have all the table information in one table

and table columns stored in another table with reference.

First i will iterate thrugh table data then

for each value in the table i am finding values in table column table

then for each of the values in the table column i am finding null values in that respective table.