https://community.qlik.com/t5/QlikView/Transforming-excel-report-into-Qlik-Table/m-p/1608848#M507359 <P>In the attached excel example excel report I have the source that I need to input into qlik and the desired target table in the next sheet.&nbsp;</P><P>Does anyone have any Idea how i can be done? I have come close but still have the Gate that I am unable to have them be repeated in every row.</P> Fri, 02 Aug 2019 09:55:34 GMT Jbekhazi 2019-08-02T09:55:34Z https://community.qlik.com/t5/QlikView/Transforming-excel-report-into-Qlik-Table/m-p/1608848#M507359 <P>In the attached excel example excel report I have the source that I need to input into qlik and the desired target table in the next sheet.&nbsp;</P><P>Does anyone have any Idea how i can be done? I have come close but still have the Gate that I am unable to have them be repeated in every row.</P> Fri, 02 Aug 2019 09:55:34 GMT https://community.qlik.com/t5/QlikView/Transforming-excel-report-into-Qlik-Table/m-p/1608848#M507359 Jbekhazi 2019-08-02T09:55:34Z https://community.qlik.com/t5/QlikView/Transforming-excel-report-into-Qlik-Table/m-p/1608863#M507360 <P>first in script you have to load the table with "order by" clause and then use the peek function.</P><P><A href="https://community.qlik.com/t5/QlikView-Documents/Using-Peek-and-Previous-Functions-Recursively-to-Help-Transform/ta-p/1492941" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Using-Peek-and-Previous-Functions-Recursively-to-Help-Transform/ta-p/1492941</A></P><P>see if the links help u</P> Fri, 02 Aug 2019 10:39:37 GMT https://community.qlik.com/t5/QlikView/Transforming-excel-report-into-Qlik-Table/m-p/1608863#M507360 miskinmaz 2019-08-02T10:39:37Z