topic Load multiple QVDS from a Folder one by one and store in other folder in QlikView

Load multiple QVDS from a Folder one by one and store in other folder

nachiket_shinde — Wed, 25 Nov 2020 16:16:04 GMT

Hello Friends,

I have few QVDs(number not defined) in folder with following format:

test_05032018

test_06032018

test_07032018

test_08032018

I have to take each file one by one , make few changes and store with same name in another folder/same folder.

Thanks in advance

Re: Load multiple QVDS from a Folder one by one and store in other folder

mrybalko — Mon, 18 Mar 2019 12:29:07 GMT

Hello @nachiket_shinde

Try the following code:

SET vInputFolder = Input;
SET vOutputFolder = Output;

FOR Each vCurFile in FileList('$(vInputFolder)\test_*.qvd')

	LET vCurFileName = SubField(vCurFile, '$(vInputFolder)\', 2);
	
	tmp:
	LOAD
		*
	From [$(vCurFile)] (qvd);
	
	STORE tmp into '$(vOutputFolder)\$(vCurFileName)' (qvd);
	
	DROP Table tmp;

NEXT //FOR Each vCurFile in FileList('$(vInputFolder)\test_*.qvd')

Re: Load multiple QVDS from a Folder one by one and store in other folder

nachiket_shinde — Mon, 18 Mar 2019 14:06:06 GMT

What if QVDs have different number of columns?

Re: Load multiple QVDS from a Folder one by one and store in other folder

mrybalko — Mon, 18 Mar 2019 14:35:08 GMT

When you use LOAD * construction it doesn't matter.