script ?

[suvechha_b]

Hi ,

Which script is correct -

1.

[DWQMV_MONTH_CLAIM_PAYMENT_TRANSACTION]:
LOAD "MONTH_CLAIM_PAYMENT_TRANSACTION_KEY",
"CLAIM_PAYMENTS_MONTH_KEY",
"CLAIM_PAYMENT_TRANSACTION_WEAKKEY",
"CLAIM_ITEM_WEAKKEY",
"CLAIM_WEAKKEY",
"CURRENCY_CODE" AS "Claim Payment Currency Code",
"TRANSACTION_DATE" AS "Claim Payment Transaction Date",
"GROSS_CLAIMS_PAID" AS "Claim Payment Gross Claims Paid",
"GROSS_CLAIMS_PAID_VAT" AS "Claim Payment Gross Claims Paid VAT";

SQL SELECT [MONTH_CLAIM_PAYMENT_TRANSACTION_KEY]
,[CLAIM_PAYMENTS_MONTH_KEY]
,[TRANSACTION_DATE]
,[GROSS_CLAIMS_PAID]
,[GROSS_CLAIMS_PAID_VAT]
FROM "DWQMV_MONTH_CLAIM_PAYMENT_TRANSACTION"
WHERE
( not [CLAIM_WEAKKEY] like '102.13|*'
and not [CLAIM_WEAKKEY] like '102.33|*'
and not [CLAIM_WEAKKEY] like '102.41|*'
and not [CLAIM_WEAKKEY] like '102.42|*');

STORE [DWQMV_MONTH_CLAIM_PAYMENT_TRANSACTION] INTO 'lib://QlikData/Model_MonthClaimPaymentTransaction.qvd' (qvd);

or

2.

[DWQMV_MONTH_CLAIM_PAYMENT_TRANSACTION]:
LOAD "MONTH_CLAIM_PAYMENT_TRANSACTION_KEY",
"CLAIM_PAYMENTS_MONTH_KEY",
"CLAIM_PAYMENT_TRANSACTION_WEAKKEY",
"CLAIM_ITEM_WEAKKEY",
"CLAIM_WEAKKEY",
"CURRENCY_CODE" AS "Claim Payment Currency Code",
"TRANSACTION_DATE" AS "Claim Payment Transaction Date",
"GROSS_CLAIMS_PAID" AS "Claim Payment Gross Claims Paid",
"GROSS_CLAIMS_PAID_VAT" AS "Claim Payment Gross Claims Paid VAT";

SQL SELECT [MONTH_CLAIM_PAYMENT_TRANSACTION_KEY]
,[CLAIM_PAYMENTS_MONTH_KEY]
,[TRANSACTION_DATE]
,[GROSS_CLAIMS_PAID]
,[GROSS_CLAIMS_PAID_VAT]
FROM "DWQMV_MONTH_CLAIM_PAYMENT_TRANSACTION"
WHERE
( not [CLAIM_WEAKKEY] like '102.13|%'
and not [CLAIM_WEAKKEY] like '102.33|%'
and not [CLAIM_WEAKKEY] like '102.41|%'
and not [CLAIM_WEAKKEY] like '102.42|%');

STORE [DWQMV_MONTH_CLAIM_PAYMENT_TRANSACTION] INTO 'lib://QlikData/Model_MonthClaimPaymentTransaction.qvd' (qvd);

[Vegar · Accepted solution]

No 2 looks right to me. In SQL SELECT use SQL syntax.

https://www.w3schools.com/sql/sql_like.asp

[walxiney_Planner]

Vegar is correct when he said you to use the https://www.w3schools.com/sql/sql_like.asp

I use the same on PLSQL you can see here https://www.techonthenet.com/oracle/like.php

...WHERE
( not [CLAIM_WEAKKEY] like '102.13|%'
and not [CLAIM_WEAKKEY] like '102.33|%'
and not [CLAIM_WEAKKEY] like '102.41|%'
and not [CLAIM_WEAKKEY] like '102.42|%')

I thing your code it's ok, whats it's return?

[Niky_D135]

Script 2 is correct.

Thanks,

Danee Nikil B