https://community.qlik.com/t5/QlikView/Any-suggestions-for-setting-up-a-SQL-Statement-Interpreter/m-p/1559804#M744188 <P>I am trying to gather lineage information on all of our QV dashboards in order to gain insight on what is feeding them. In order to do this, I want to be able to parse through the Statement in the XML metadata.</P><P><U><STRONG>Are there currently any SQL statement Interpreter QVWs that anyone knows of? Or does anyone have any suggestions on where to start?</STRONG></U></P><P>Otherwise, I was planning on either pulling the SQL Server Database name from between the "USE" and the ";", but I realized if there are any joins being made, I would need to search between the from statement...</P> Sat, 16 Nov 2024 04:05:07 GMT Cmurphy55 2024-11-16T04:05:07Z https://community.qlik.com/t5/QlikView/Any-suggestions-for-setting-up-a-SQL-Statement-Interpreter/m-p/1559804#M744188 <P>I am trying to gather lineage information on all of our QV dashboards in order to gain insight on what is feeding them. In order to do this, I want to be able to parse through the Statement in the XML metadata.</P><P><U><STRONG>Are there currently any SQL statement Interpreter QVWs that anyone knows of? Or does anyone have any suggestions on where to start?</STRONG></U></P><P>Otherwise, I was planning on either pulling the SQL Server Database name from between the "USE" and the ";", but I realized if there are any joins being made, I would need to search between the from statement...</P> Sat, 16 Nov 2024 04:05:07 GMT https://community.qlik.com/t5/QlikView/Any-suggestions-for-setting-up-a-SQL-Statement-Interpreter/m-p/1559804#M744188 Cmurphy55 2024-11-16T04:05:07Z