

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load where not match two criterias
Hi, I would like to exclude certain rows from my load script witch matches both in ID and Date fields. Ex. ID=1,Date<20210103 and ID=2, Date<20210102. I have tried LOAD WHERE Not Match, but I'm not able to use to criterias. Any ideas?
ID | Date |
1 | 20210101 |
1 | 20210102 |
1 | 20210103 |
1 | 20210104 |
2 | 20210101 |
2 | 20210102 |
2 | 20210103 |
3 | 20210101 |
3 | 20210102 |
3 | 20210103 |
3 | 20210104 |
3 | 20210105 |
3 | 20210106 |
3 | 20210107 |
3 | 20210108 |
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Found a workaround 🙂
Created qvd-files for the wanted ID's and dates. Joined them to a new wanted.qvd
Removed all relevant ID's from my original file, saved to a new cleaned.qvd, and then joined wanted.qvd and cleaned.qvd to a new full.qvd.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Something like below ?
Table:
Load * Inline [
ID, Date
1, 20210101
1, 20210102
1, 20210103
1, 20210104
2, 20210101
2, 20210102
2, 20210103
3, 20210101
3, 20210102
3, 20210103
3, 20210104
3, 20210105
3, 20210106
3, 20210107
3, 20210108
] Where (ID=1 and Date<'20210103') Or (ID=2 and Date<'20210102');
Output :


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, this could work, but my wanted excluded data contains about 800 ID's and 150 dates per ID . Is there a different way?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Dates you want to exclude, do you have the specific dates are are they < as in your example?
-Rob


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Specific dates, but not the same for all the ID's.
They all have dates -> 05.10.21 and I want to set a new "last date". Some will have 01.02.21, others 01.03.21 or 01.04.21 and so on.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Found a workaround 🙂
Created qvd-files for the wanted ID's and dates. Joined them to a new wanted.qvd
Removed all relevant ID's from my original file, saved to a new cleaned.qvd, and then joined wanted.qvd and cleaned.qvd to a new full.qvd.
