Exclude certain conditions

[#1]

Hi,

I have a source file, field formats as below:

ID	Time	FieldA	FieldB	FieldC
1	8:00
2	8:00
3	8:00
4	8:00
5	8:00
6	8:00
7	8:00
8	8:00
9	8:00
10	8:00
11	8:00
12	8:00
13	8:00
14	8:00

I would like to exclude the following IDs and time from the source

ID	Time	Condition
1	8:00	TRUE
2	9:00	TRUE
3	8:00	TRUE
1	9:00	TRUE
2	10:00	TRUE
1	10:00	TRUE
2	11:00	TRUE
1	11:00	TRUE
2	12:00	TRUE
3	9:00	TRUE
4	8:00	TRUE
5	9:00	TRUE
6	10:00	TRUE
4	9:00	TRUE

How can I do that?  the time and ID are generic, basically, each person will have time ranging from 08:00 to 20:00.

Hope you could help to provide the answer in words as i cannot open other's qvw file...

thanks!

[tresesco]

Are these conditions discrete? can't you generalize it? To exclude them during load you have to use WHERE clause. But using them with OR would make it explicit/hard coded, not sure if your requirement demands so or not.

Thanks.

[swuehl]

You can possibly create a composite key made of ID and Time, then load your exclusion table first and use

...

where not exists(Key);

when loading your main table.

[#4]

Hi,

THanks. This condition is discrete.  If i would like to exclude them in the load condition, how can i do that?