topic Re: Expression in QlikView

Expression

Fri, 17 Jul 2015 11:54:42 GMT

Hi Experts,

how to write this expression in our QV, I got the req from users and I need to covert it to QV

select A.CHECK_ERROR_NUMBER, A.CONTRACT_REFERENCE, B.NUMMSG, B.PRODUCTS, C.MESSAGE from RETAIL_EXPOSURE#CR A, TABLE_CONSTRAINTS B, ERROR_MESSAGES C
where A.CHECK_ERROR_NUMBER = B.CONSTRAINT_ID and A.CHECK_ERROR_NUMBER = '9846' AND CONTRACT_REFERENCE = 'MMJYQJYJYT'
AND B.NUMMSG = C.NUMMSG
AND B.TABLE_NAME = C.TABLE_NAME
AND B.NUMMSG = '20034'

Re: Expression

alex_millan — Fri, 17 Jul 2015 12:03:07 GMT

Hi,

If the sql transaction works properly, there's no need to adjust almost anything. Obviously, previous to the following sentence, you should construct the connection string to the SQL Server and database.

Table1:

LOAD *;

SQL select

A.CHECK_ERROR_NUMBER,

A.CONTRACT_REFERENCE,

B.NUMMSG, B.PRODUCTS,

C.MESSAGE

From RETAIL_EXPOSURE#CR A, TABLE_CONSTRAINTS B, ERROR_MESSAGES C

Where

A.CHECK_ERROR_NUMBER = B.CONSTRAINT_ID

And A.CHECK_ERROR_NUMBER = '9846'

And CONTRACT_REFERENCE = 'MMJYQJYJYT'

And B.NUMMSG = C.NUMMSG

And B.TABLE_NAME = C.TABLE_NAME

And B.NUMMSG = '20034';

Regards.

Re: Expression

alex_millan — Fri, 17 Jul 2015 12:28:41 GMT

Hi Raj,

were you finally able to load the data? If so, please mark the answer as correct to close the thread.

If not, do not hesitate to ask for further help

Cheers!