topic Re: Load where not match two criterias in App Development

Load where not match two criterias

rikkeqlik — Thu, 06 Jan 2022 08:37:58 GMT

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

Re: Load where not match two criterias

AshutoshBhumkar — Thu, 06 Jan 2022 08:53:05 GMT

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 :

Re: Load where not match two criterias

rikkeqlik — Thu, 06 Jan 2022 09:08:10 GMT

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?

Re: Load where not match two criterias

rwunderlich — Thu, 06 Jan 2022 17:26:42 GMT

The Dates you want to exclude, do you have the specific dates are are they < as in your example?

-Rob

Re: Load where not match two criterias

rikkeqlik — Fri, 07 Jan 2022 08:04:46 GMT

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.

Re: Load where not match two criterias

rikkeqlik — Fri, 07 Jan 2022 12:56:02 GMT

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.