topic oracle in QlikView https://community.qlik.com/t5/QlikView/oracle/m-p/1444817#M803485 <HTML><HEAD></HEAD><BODY><P>I have a oracle database to externally maintain my files and we use a an ETL to extract from these tables and place into a file server...in form of .txt files/ - approximately around 200- 400 files</P><P></P><P>These .txt files are used in different qlikview reports I have totally around 350-400 reports.</P><P></P><P>Is there a way to identify which text files are used in which reports?</P><P></P><P>any suggestions</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT raadwiptec 2020-11-25T16:16:04Z oracle https://community.qlik.com/t5/QlikView/oracle/m-p/1444817#M803485 <HTML><HEAD></HEAD><BODY><P>I have a oracle database to externally maintain my files and we use a an ETL to extract from these tables and place into a file server...in form of .txt files/ - approximately around 200- 400 files</P><P></P><P>These .txt files are used in different qlikview reports I have totally around 350-400 reports.</P><P></P><P>Is there a way to identify which text files are used in which reports?</P><P></P><P>any suggestions</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/oracle/m-p/1444817#M803485 raadwiptec 2020-11-25T16:16:04Z Re: oracle https://community.qlik.com/t5/QlikView/oracle/m-p/1444818#M803486 <HTML><HEAD></HEAD><BODY><P>The easiest way is to include the names of the file you load in the tables into which you load the data. In the reports you can then show from which files the data comes.</P><P></P><P>Or perhaps a solution like <A href="https://www.nodegraph.se/solutions/" title="https://www.nodegraph.se/solutions/">nodegraph</A>‌.</P></BODY></HTML> Thu, 09 Nov 2017 10:18:18 GMT https://community.qlik.com/t5/QlikView/oracle/m-p/1444818#M803486 Gysbert_Wassenaar 2017-11-09T10:18:18Z Re: oracle https://community.qlik.com/t5/QlikView/oracle/m-p/1444819#M803487 <HTML><HEAD></HEAD><BODY><P>If you use the Governance Dashboard, there´s reports called "Lineage' that can help you</P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182659_Capturar.PNG" style="height: 332px; width: 620px;" /></P></BODY></HTML> Thu, 09 Nov 2017 10:22:04 GMT https://community.qlik.com/t5/QlikView/oracle/m-p/1444819#M803487 Clever_Anjos 2017-11-09T10:22:04Z