This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
File example 2:
File example 3:
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
If(@3='Volume1', as volume1,
if(@3='Heat1', as Heat1,
if(@3='Temperature' as Temperature)))
//and so on....
if the structure is the same between files and the fields are different, i think this solution works.
load * from lib;\\mylib\*.csv
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.