topic Re: Load all files from folder, and treat files different depending on con in QlikView

How to use Dynamic header on different headers and rows.

varmekontrol — Sat, 16 Nov 2024 04:07:55 GMT

Confusing subject i know.. but let me try to explain what I need 🙂

I need to load all .csv files from a folder into a .qvd file.
That task of loading all files is simple enough, but herein lies my question.

There are about 6 different .csv files in this folder, that varies in headers, and field contents.

File example 1:

SerialNo

Created

Volume1

Volume2

Volume3

Volume4

File example 2:

SerialNo

Created

Heat1

Heat2

Heat3

Heat4

Temperature

Delta-T

ErrorCode

File example 3:

SerialNo

Created

Temperature1

Temperature2

Temperature3

Humidity1

Humidity2

Humidity3

What I need to do is load all the files in a folder, but depending on the headers, they should be treated differently. Not only the header but the contents that comes with it in that field.

//something like this

Load 
	SerialNo,
	Created,
		If(@3='Volume1', as volume1, 
		if(@3='Heat1', as Heat1,
		if(@3='Temperature' as Temperature)))
	
		if(@4=''
		
		//and so on....

Re: Load all files from folder, and treat files different depending on con

juliensaintmaxent3113 — Mon, 18 Mar 2019 14:36:48 GMT

hi,

if the structure is the same between files and the fields are different, i think this solution works.

load * from lib;\\mylib\*.csv

bye

Re: Load all files from folder, and treat files different depending on con

varmekontrol — Tue, 19 Mar 2019 07:31:49 GMT

That did not do the job.
When doing so I, first of all, get a lot of syn_keys (15 in total)

Second, the data is just mixed in the fields, and not separated into the right columns.

Example 1 and Example 2 is attached.