topic Transform or Specify Excel File Cell Import Structure in QlikView https://community.qlik.com/t5/QlikView/Transform-or-Specify-Excel-File-Cell-Import-Structure/m-p/41142#M783202 <HTML><HEAD></HEAD><BODY><P>Hi. We have a huge data set of excel files that a colleague used to chart patient's behavior from week to week. He uses the same excel sheet format from week to week and we want to be able to import it into Qlikview. However, his format does not follow the typical row-by-row that we all know is best for importing data. Is there a way for met to tell Qlikview where certain information is per sheet? For example, Name is at B1, Date is at B2, MAM Goal is at C3, and so on.&nbsp; Screenshot of it is below.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196606_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT proctors 2020-11-25T16:16:04Z Transform or Specify Excel File Cell Import Structure https://community.qlik.com/t5/QlikView/Transform-or-Specify-Excel-File-Cell-Import-Structure/m-p/41142#M783202 <HTML><HEAD></HEAD><BODY><P>Hi. We have a huge data set of excel files that a colleague used to chart patient's behavior from week to week. He uses the same excel sheet format from week to week and we want to be able to import it into Qlikview. However, his format does not follow the typical row-by-row that we all know is best for importing data. Is there a way for met to tell Qlikview where certain information is per sheet? For example, Name is at B1, Date is at B2, MAM Goal is at C3, and so on.&nbsp; Screenshot of it is below.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196606_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Transform-or-Specify-Excel-File-Cell-Import-Structure/m-p/41142#M783202 proctors 2020-11-25T16:16:04Z Re: Transform or Specify Excel File Cell Import Structure https://community.qlik.com/t5/QlikView/Transform-or-Specify-Excel-File-Cell-Import-Structure/m-p/41143#M783203 <HTML><HEAD></HEAD><BODY><P>Hi - to convert the format(kind of pivot table) that you have in excel, you need to be able to write some script to convert into qlikview readable table data.</P><P></P><P>please post your excel with smple data and your desired output.we can play around with it.</P></BODY></HTML> Sat, 17 Mar 2018 03:53:44 GMT https://community.qlik.com/t5/QlikView/Transform-or-Specify-Excel-File-Cell-Import-Structure/m-p/41143#M783203 Qrishna 2018-03-17T03:53:44Z