topic Split a file in QlikView

Split a file

Wed, 12 Oct 2016 06:27:47 GMT

Hello,

I have an Excel file with budget data and for each customer is there one line with

one column for each month. How do I load this file to get one record pro month?

This is the infile:

This is what I would like to get:

kindly

Håkan

tamilarasu — Wed, 12 Oct 2016 06:42:47 GMT

Hi Håkan,

You can use cross table option to get the above result.

Data:

CrossTable(Month, Amount)
LOAD Customer,
Jan,
Feb,
Mar,
Apr
FROM
[Your Excel File]

(ooxml, embedded labels, table is Sheet1);

I have attached a sample file for your reference.

Wed, 12 Oct 2016 06:52:29 GMT

Thanks for a very fast and correct answer.

kindly

Håkan