Nested Looping Frustrations - I just can't see it!

[RW9]

Hi,

Nope, still not seeing the big picture here.  I don't see why a simple conbine of the two datasets, and then generate some code would not work?  What is the purpose of creating X amount of datasets for each loop as well, that doesn't seem to be an efficient way of working - it then means all your further code has to account for lots of datasets - extra work.  As I say above collect your thoughts, what are the input datasets (all of them - examples) and what the output should look like.  Me, I would create a set of flags in the one dataset for each "test", and then you only have one dataset to work with and selectable flags, but as I mention it is very hard to provide anything as we are only seeing bits and pieces.

[buechler66]

I appreciate your time so much. I'll get to work on this in the morning.

Btw- the reason for each looping, individual query by Rule is that if a record meets the Rule #1 condition then it needs to be excluded from any later rule query. Each record can count toward only the first Rule condition it meets. So I plan to run a query for Rule #1 and then append it to my FinalData ds . Then I plan to apply a Unique index on the Primary Key variable of Imb_code. This will keep records (imb_codes) from later Rules from being appended to FinalData. That's where I'm ultimately headed.

Thanks again. I hope I can take your advice and get this thing running.