topic Get DataModel fields names and values in App Development https://community.qlik.com/t5/App-Development/Get-DataModel-fields-names-and-values/m-p/1429799#M34297 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I <SPAN style="font-size: 10pt;">Would like to know the fieldnames and values of my dataModel. </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I use the GetTablesAndKeys method get a list of the fieldnames.</SPAN></P><P></P><P>it returns this list of <STRONG>fieldnames</STRONG>:</P><P></P><P>VerkoopkansKey</P><P>LeadKey</P><P>DatumKey</P><P>RelatieKey</P><P>Division</P><P></P><P>Then i get the <STRONG>fieldvalues </STRONG>with the method getTableData:</P><P></P><P>it returns this list of <STRONG>fieldvalues</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>VK001</STRONG></P><P><STRONG>LE001</STRONG></P><P><STRONG>DIV001&nbsp; - these are switched<BR /></STRONG></P><P><STRONG>REL001&nbsp; - <BR /></STRONG></P><P></P><P>as you can see the names and values are not in the same order and i wonder <STRONG>why the Qlik Sense API doesnt have a method that returns an object with BOTH the name AND the value </STRONG>of the tableModel, instead of separating them.</P><P></P><P>Whats even more worrying is that the Qlik Sense <STRONG>engine-api-explorer</STRONG> returns this list of <STRONG>fieldnames:</STRONG></P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P><SPAN style="font-size: 13.3333px;">LeadKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">VerkoopkansKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">RelatieKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">DatumKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">Division</SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;">This list is ALSO in a different order than the list of fieldvalues.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any help would be appreciated.<BR /></SPAN></P><P></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Tue, 07 Nov 2017 14:40:38 GMT Anonymous 2017-11-07T14:40:38Z Get DataModel fields names and values https://community.qlik.com/t5/App-Development/Get-DataModel-fields-names-and-values/m-p/1429799#M34297 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I <SPAN style="font-size: 10pt;">Would like to know the fieldnames and values of my dataModel. </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I use the GetTablesAndKeys method get a list of the fieldnames.</SPAN></P><P></P><P>it returns this list of <STRONG>fieldnames</STRONG>:</P><P></P><P>VerkoopkansKey</P><P>LeadKey</P><P>DatumKey</P><P>RelatieKey</P><P>Division</P><P></P><P>Then i get the <STRONG>fieldvalues </STRONG>with the method getTableData:</P><P></P><P>it returns this list of <STRONG>fieldvalues</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>VK001</STRONG></P><P><STRONG>LE001</STRONG></P><P><STRONG>DIV001&nbsp; - these are switched<BR /></STRONG></P><P><STRONG>REL001&nbsp; - <BR /></STRONG></P><P></P><P>as you can see the names and values are not in the same order and i wonder <STRONG>why the Qlik Sense API doesnt have a method that returns an object with BOTH the name AND the value </STRONG>of the tableModel, instead of separating them.</P><P></P><P>Whats even more worrying is that the Qlik Sense <STRONG>engine-api-explorer</STRONG> returns this list of <STRONG>fieldnames:</STRONG></P><P><STRONG style="font-size: 13.3333px;"><BR /></STRONG></P><P><SPAN style="font-size: 13.3333px;">LeadKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">VerkoopkansKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">RelatieKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">DatumKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">Division</SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;">This list is ALSO in a different order than the list of fieldvalues.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any help would be appreciated.<BR /></SPAN></P><P></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Tue, 07 Nov 2017 14:40:38 GMT https://community.qlik.com/t5/App-Development/Get-DataModel-fields-names-and-values/m-p/1429799#M34297 Anonymous 2017-11-07T14:40:38Z Re: Get DataModel fields names and values https://community.qlik.com/t5/App-Development/Get-DataModel-fields-names-and-values/m-p/1429800#M34298 <HTML><HEAD></HEAD><BODY><P>Very frustrating indeed. Same issue here and I've tried it with the newest version of Qlik / SDK.</P></BODY></HTML> Tue, 16 Oct 2018 18:08:31 GMT https://community.qlik.com/t5/App-Development/Get-DataModel-fields-names-and-values/m-p/1429800#M34298 Anonymous 2018-10-16T18:08:31Z