Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

script ?

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);

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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

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

View solution in original post

3 Replies
Vegar
MVP
MVP

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

https://www.w3schools.com/sql/sql_like.asp
walxiney_Planner
Partner - Contributor III
Partner - Contributor III

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
Contributor
Contributor

Script 2 is correct.

 

Thanks,

Danee Nikil B