How fill some cells from excel file?

[#1]

Hi all.

I have a Excel file with grouped data rows. Example:

Article	Nomenclature	Quantity
	Warehouse 1
	Inflow from 01-01-2014
4555-16	Mug	50
1924-16	Coffee Pot	20
10688-18	Teapot	10
	Outflow from 31-01-2014
455-16	Mug	15
1924-16	Coffee Pot	9
10688-18	Teapot	6

Yes! Stupid base

I need transpose and fill data and create next table in QV:

Warehouses	Inflow/Outflow	Article	Nomenclature	Quantity
Warehouse 1	Inflow from 01-01-2014	4555-16	Mug	50
Warehouse 1	Inflow from 01-01-2014	1924-16	Coffee Pot	20
Warehouse 1	Inflow from 01-01-2014	10688-18	Teapot	10
Warehouse 1	Outflow from 31-01-2014	455-16	Mug	15
Warehouse 1	Outflow from 31-01-2014	1924-16	Coffee Pot	9
Warehouse 1	Outflow from 31-01-2014	10688-18	Teapot	6

How I can did it? Any ideas.

Thank you.

[igor-st80]

macro in excel and run it before load data in QV

[#3]

If I understand correctly:

1. Open XLS file

2. Run Macros

3. Save XLS file after macros finished

4. Load in QV.

Correctly?

[rwunderlich]

You can load this with some conditional logic and multiple passes over the data. See an example at:

Qlikview Cookbook: Load Input File Containing Multiple Record Types http://qlikviewcookbook.com/recipes/download-info/load-input-file-containing-multiple-record-types/

-Rob

http://masterssummit.com

http://robwunderlich.com

[mahesh_agrawal · Accepted solution]

Hi Dmitry,

Please find the attached Excel along with QVW fille.

I hope it answers your problem.

[#6]

An easy and well performing solution.... Well Done Mahesh Agrawal

[preminqlik]

hi mahesh..superlike

[#8]

Mahesh, it's great!

I created macro in excel with this principle, but I don't know how write it in QV.

Thank for solution and algorithm.

[mahesh_agrawal]

You are most welcome

[rohit214]

well done mahesh