topic Re: create new table from record in QlikView https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123020#M18751 <HTML><HEAD></HEAD><BODY><P>Use a WHILE loop in your LOAD statement.</P><P></P><P>Have a look at</P><P><A href="https://community.qlik.com/qlik-blogpost/2940">Creating Reference Dates for Intervals</A></P></BODY></HTML> Sat, 20 Oct 2018 19:36:38 GMT swuehl 2018-10-20T19:36:38Z create new table from record https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123019#M18750 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>I have a table from google calendar.&nbsp; </P><P>it's like </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>event</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>from</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>to</STRONG></TH></TR><TR><TD style="padding: 2px;">new year</TD><TD style="padding: 2px;">28/12/2018</TD><TD style="padding: 2px;">1/1/2019</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">11/11/2018</TD><TD style="padding: 2px;">11/11/2018</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1/10/2018</TD><TD style="padding: 2px;">2/10/2018</TD></TR></TBODY></TABLE><P></P><P>and I want to make like <SPAN style="font-size: 13.3333px;">a calendar</SPAN> for integration with my <SPAN style="font-size: 13.3333px;">calendar </SPAN>in QlikView </P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; font-size: 13.3333px; text-align: center;">event</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">new year</SPAN></TD><TD style="padding: 2px;">28/12/2018</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">new year</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">29/12/2018</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">new year</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">30/12/2018</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">new year</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">31/12/2018</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">new year</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">1/1/2019</SPAN></TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/11/2018</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">1/10/2018</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">2/10/2018</SPAN></TD></TR></TBODY></TABLE><P></P><P>Can someone help me to make it in the script?</P></BODY></HTML> Sat, 20 Oct 2018 19:29:31 GMT https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123019#M18750 abdulaziz 2018-10-20T19:29:31Z Re: create new table from record https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123020#M18751 <HTML><HEAD></HEAD><BODY><P>Use a WHILE loop in your LOAD statement.</P><P></P><P>Have a look at</P><P><A href="https://community.qlik.com/qlik-blogpost/2940">Creating Reference Dates for Intervals</A></P></BODY></HTML> Sat, 20 Oct 2018 19:36:38 GMT https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123020#M18751 swuehl 2018-10-20T19:36:38Z Re: create new table from record https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123021#M18752 <HTML><HEAD></HEAD><BODY><P>I think you mean IterNo with While</P><P>I try this in the link and its work well</P><P>many thanks</P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctions/IterNo.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctions/IterNo.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctions/IterNo.htm</A></P></BODY></HTML> Sat, 20 Oct 2018 20:20:05 GMT https://community.qlik.com/t5/QlikView/create-new-table-from-record/m-p/123021#M18752 abdulaziz 2018-10-20T20:20:05Z