topic Re: Problem in Select Query in QlikView

Problem in Select Query

Thu, 03 Apr 2014 05:06:28 GMT

Dear Experts,

AUSP:

LOAD

ATINN,

ATWRT,

OBJEK;

SQL SELECT ATINN ATWRT OBJEK FROM AUSP

WHERE ATINN = 'MKTG_ACCT_MGR1';

In above SQL Select query 0 lines fetched. In SAP MKTG_ACCT_MGR1 is exists.

However, it shows 0 lines.

Kindly suggest the same.

Thanks and Regards

Amol Khochare

Re: Problem in Select Query

Thu, 03 Apr 2014 05:39:59 GMT

Try loading everything into the QV table - then check in that loaded data whether MKTG_ACCT_MGR1 exists.

If it does copy the output value and use it in the WHERE clause of the SQL query, or, resident load AUSP1 with the criteria to only pull through the MGR1 data.