Discussion Board for collaboration on QlikView Scripting.
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
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.