Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
@Hey guys,
I'm a newbie in the Qlikview world and require your support in resolving 2 queries:
1. I intend to read data into Qlikview from multiple CSV files and correspondingly, use that data to plot a graph. Each of these files also contain some unwanted header information and the data to be read from all files is also identical
My intention is to load these files, delimit them to remove the unwanted headers and to extract the required data information into separate tables.[For Y1, Y2]
2. I loaded a single CSV file and tried to extract the required data. The script runs successfully, but I did not receive any information in the corresponding fields. Please find code used for this particular operation
Also, I did not face this problem while importing and carrying out the operation on a XLS file.
Code:
A:
LOAD "X [ms]",Y1,Y2,Y3,Y4,Y5,Y6,Y7,Y8 as Data
FROM
[..\Test.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 17 lines);
B:
LOAD SubField(Data, ',' ,5) as Relative,
SubField(Data, ',' ,2) as Bit
Resident A;
DROP Table A;
Could anyone suggest the best way to carry out these activities?
Thanks!! .