topic Transformation Excel in Script in QlikView https://community.qlik.com/t5/QlikView/Transformation-Excel-in-Script/m-p/1386073#M799925 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P></P><P>I saw tons of tutorials about transformation wizard, and i'm trying replicate the power of that tool using functions.</P><P></P><P>I have something like dat</P><P></P><P>Field A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Field B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Field C&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Field D&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field E</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h</P><P>b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ç&nbsp;&nbsp;&nbsp;&nbsp; </P><P>c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp; </P><P>d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</P><P>f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; o</P><P>f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; o&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i</P><P></P><P>So i want eliminate the lines bellow when in field B appear null for the 1st time. And i want elimate the columns dat have null values.</P><P></P><P>I tried something like this (for the columns with null values)</P><OL class="dp-c" start="1" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; list-style-position: initial; list-style-image: initial; color: #5c5c5c; margin: 0 0 1px 45px !important;"><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;"><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">FOR a = </SPAN><SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;"> TO NoOfTables() - </SPAN><SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">1</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; LET vTable = TableName($(a));&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; LET d = <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">;&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; FOR i = <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">1</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;"> TO NoOfFields(</SPAN><SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; background-color: inherit; font-size: 9pt !important;">'$(vTable)'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">)&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET j = i - d;&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET vField = FieldName($(j), <SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; background-color: inherit; font-size: 9pt !important;">'$(vTable)'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">);&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET vFieldValueCount = Alt(FieldValueCount(<SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; background-color: inherit; font-size: 9pt !important;">'$(vField)'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">), </SPAN><SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">);&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (vFieldValueCount &lt;= <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;"> ) THEN&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DROP FIELD [$(vField)] FROM $(vTable);&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRACE DROP FIELD [$(vField)] FROM $(vTable);&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET d = d + <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">1</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">; </SPAN><SPAN class="comment" style="font-weight: inherit; font-style: inherit; color: #008200; background-color: inherit; font-size: 9pt !important;">// dropping fields impacts the internal field no.</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NEXT i&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; NEXT a&nbsp; </SPAN></LI></OL><P><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;"> </SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">But always error for different reasons.<BR />Thanks in advance<BR />Best Regards<BR />Bruno Paulo<BR /><BR /><BR /><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brunopaulo 2020-11-25T16:16:04Z Transformation Excel in Script https://community.qlik.com/t5/QlikView/Transformation-Excel-in-Script/m-p/1386073#M799925 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P></P><P>I saw tons of tutorials about transformation wizard, and i'm trying replicate the power of that tool using functions.</P><P></P><P>I have something like dat</P><P></P><P>Field A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Field B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Field C&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Field D&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field E</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h</P><P>b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ç&nbsp;&nbsp;&nbsp;&nbsp; </P><P>c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp; </P><P>d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b</P><P>f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; o</P><P>f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; o&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i</P><P></P><P>So i want eliminate the lines bellow when in field B appear null for the 1st time. And i want elimate the columns dat have null values.</P><P></P><P>I tried something like this (for the columns with null values)</P><OL class="dp-c" start="1" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; list-style-position: initial; list-style-image: initial; color: #5c5c5c; margin: 0 0 1px 45px !important;"><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;"><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">FOR a = </SPAN><SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;"> TO NoOfTables() - </SPAN><SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">1</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; LET vTable = TableName($(a));&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; LET d = <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">;&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; FOR i = <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">1</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;"> TO NoOfFields(</SPAN><SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; background-color: inherit; font-size: 9pt !important;">'$(vTable)'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">)&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET j = i - d;&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET vField = FieldName($(j), <SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; background-color: inherit; font-size: 9pt !important;">'$(vTable)'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">);&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET vFieldValueCount = Alt(FieldValueCount(<SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; background-color: inherit; font-size: 9pt !important;">'$(vField)'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">), </SPAN><SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">);&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF (vFieldValueCount &lt;= <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">0</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;"> ) THEN&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DROP FIELD [$(vField)] FROM $(vTable);&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRACE DROP FIELD [$(vField)] FROM $(vTable);&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LET d = d + <SPAN class="number" style="font-weight: inherit; font-style: inherit; color: green; background-color: inherit; font-size: 9pt !important;">1</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">; </SPAN><SPAN class="comment" style="font-weight: inherit; font-style: inherit; color: #008200; background-color: inherit; font-size: 9pt !important;">// dropping fields impacts the internal field no.</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">&nbsp; </SPAN></SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NEXT i&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">&nbsp;&nbsp;&nbsp; NEXT a&nbsp; </SPAN></LI></OL><P><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;"> </SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;">But always error for different reasons.<BR />Thanks in advance<BR />Best Regards<BR />Bruno Paulo<BR /><BR /><BR /><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Transformation-Excel-in-Script/m-p/1386073#M799925 brunopaulo 2020-11-25T16:16:04Z Re: Transformation Excel in Script https://community.qlik.com/t5/QlikView/Transformation-Excel-in-Script/m-p/1386074#M799926 <HTML><HEAD></HEAD><BODY><P>Hi Bruno</P><P><IMG alt="TRANSF_GENERIC.gif" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184943_TRANSF_GENERIC.gif" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Tue, 28 Nov 2017 15:35:51 GMT https://community.qlik.com/t5/QlikView/Transformation-Excel-in-Script/m-p/1386074#M799926 el_aprendiz111 2017-11-28T15:35:51Z