topic Re: store error in QlikView

store error

bushpalaamarnat — Wed, 08 Aug 2018 15:30:58 GMT

Hello All,

In a folder i have 4 files, am covnerting into qvd by loading all files. how ever only 1 and 4 files are converting into one qvd. file 2 and 3 as u can see in the screen shot the file is showing -1 and not data is flowing into qvd.

Can you help?

Re: store error

sunny_talwar — Wed, 08 Aug 2018 15:33:09 GMT

What is your script that you are using? If they are getting auto-concatenated then do they have the same exact fields?

Re: store error

bushpalaamarnat — Thu, 09 Aug 2018 07:17:54 GMT

AllFile:

LOAD *

FROM

(ooxml, embedded labels);

STORE AllFile into C:\Users\nbb31875\Desktop\Desktop\Qlik\Corridor Invalid Status\Data\Output QVD\ICR_Load.qvd(qvd);

STORE AllFile into Z:\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Output QVD\ICR_Load.qvd(qvd);

Re: store error

sibin_jacob — Thu, 09 Aug 2018 07:31:42 GMT

Please check the name of the column and count of columns in the file.

File 1 and File 4 having the same name of the column and count of column also same.

then it will autoconcatnate into AllFile table,

if it is different then it will create a new table.(AllFile-1)

Re: store error

sibin_jacob — Thu, 09 Aug 2018 07:37:29 GMT

To solve this issue for this scenario, you can write like this,

AllFile:

LOAD *

FROM

(ooxml, embedded labels);

Concatenate(AllFile)

Load * Resident AllFile-1;

drop table AllFile-1;

Re: store error

bushpalaamarnat — Thu, 09 Aug 2018 08:06:57 GMT

Thank you! i got what you suggested. it is really helpful.

Re: store error

sunny_talwar — Thu, 09 Aug 2018 10:10:34 GMT

What sibin.jacob‌ is def. an option, but I also recommend looking into For... Next loop Loops in the Script‌ to load your files... the reason I say is that in this case you know that there could be 2 variation of files that can came through... but what if there are N number of different variations that can happen...