Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What is your script that you are using? If they are getting auto-concatenated then do they have the same exact fields?
What is your script that you are using? If they are getting auto-concatenated then do they have the same exact fields?
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);
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)
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;
Thank you! i got what you suggested. it is really helpful.
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...