Discussion Board for collaboration on QlikView Layout & Visualizations.
How to load following type of excel data........ Please reply me ASAP..
please mention the types.....
Normally we load data from excel by selecting a excel file with data in select datasource tab create new document workflow tab.
in your question you just mentioned 'load following type of excel data' and didn't list any data.
Actually image is not pasted..... anyways
i want to load following type of data
Column1 Column2 Column3
ABC A1 B1
XYZ X1 Y1
If you have excel file having the data as above. just load the file into QV.
I am not able to understand what is the difficulty you are facing.
please elaborate your Question.
You can add a load filter to fill in empty values:
Load Column1, Column2, Column3
(ooxml, embedded labels, table is Table1, filters(Replace(1, top, StrCnd(null))));
You can build such a filter with the transformation wizard. See here for an example.
clicking Table tab
Load your data
Next from File Wizard : File Wizard : TransaFormation
Enable Transformation Steps
go to Fill Tab
click "Fill" Button
Specifiy the target Column and go to Cell Condition and say ok without changing any settings
once you say ok, now you`d see the empty rows would have been filled with the informations and say Next and Finsih.
Please check the following URL