topic Identify table,fields and Field values. in QlikView https://community.qlik.com/t5/QlikView/Identify-table-fields-and-Field-values/m-p/1332878#M835912 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Actually I received BRD of following type ? how to identify </SPAN><SPAN style="font-size: 13.3333px;">table,fields and Field values from the following SQL Code ?</SPAN></P><P><SPAN style="font-size: 13.3333px;">What indicates,</SPAN></P><P><SPAN style="font-size: 13.3333px;">1&gt;det</SPAN></P><P><SPAN style="font-size: 13.3333px;">2&gt;temp</SPAN></P><P><SPAN style="font-size: 13.3333px;">3&gt;r</SPAN></P><P><SPAN style="font-size: 13.3333px;">4&gt;Term after temp. and r.&nbsp; <BR /></SPAN></P><P></P><P>select * from</P><P>(select det.*,</P><P>temp.BATCHOUTPUT,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>temp.reason,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>temp.JOB_START_DTTM BatchDate,</P><P>r.RO_NAME LocationName,</P><P>row_number() over (partition by policyproposalnumber order by&nbsp; RO_NAME ) seq</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT dhavalvyas 2020-11-25T16:16:04Z Identify table,fields and Field values. https://community.qlik.com/t5/QlikView/Identify-table-fields-and-Field-values/m-p/1332878#M835912 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Actually I received BRD of following type ? how to identify </SPAN><SPAN style="font-size: 13.3333px;">table,fields and Field values from the following SQL Code ?</SPAN></P><P><SPAN style="font-size: 13.3333px;">What indicates,</SPAN></P><P><SPAN style="font-size: 13.3333px;">1&gt;det</SPAN></P><P><SPAN style="font-size: 13.3333px;">2&gt;temp</SPAN></P><P><SPAN style="font-size: 13.3333px;">3&gt;r</SPAN></P><P><SPAN style="font-size: 13.3333px;">4&gt;Term after temp. and r.&nbsp; <BR /></SPAN></P><P></P><P>select * from</P><P>(select det.*,</P><P>temp.BATCHOUTPUT,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>temp.reason,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>temp.JOB_START_DTTM BatchDate,</P><P>r.RO_NAME LocationName,</P><P>row_number() over (partition by policyproposalnumber order by&nbsp; RO_NAME ) seq</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Identify-table-fields-and-Field-values/m-p/1332878#M835912 dhavalvyas 2020-11-25T16:16:04Z