Skip to Content
0
Mar 15, 2011 at 04:50 PM

Download Query execution to a File - APD

87 Views

Hi,

I would like to download to a file the execution of a Query. I thought in APD, but I am facing an issue.

The layout of the query is the following (and as I expect to be in the flat file):

 	 					KF 1		KF 1		KF 1		KF 2		KF 2		KF 2
			Calendar day		01/02/2011	02/02/2011	03/02/2011	01/02/2011	02/02/2011	03/02/2011
Customer group		Material	 	 	 	 	 	 
A1			000000000030193470	10		12		14		16		18		20
A1			000000000030193473	12		15		18		21		24		27

But the layout of the file is:

Customer group	Material		Calendar day	KF 1	KF 2
A1		000000000030193470	01/02/2011	10	12
A1		000000000030193470	02/02/2011	12	15
A1		000000000030193470	03/02/2011	14	18
A1		000000000030193473	01/02/2011	16	21
A1		000000000030193473	02/02/2011	18	24
A1		000000000030193473	03/02/2011	20	27

My query has in Row 2 Characteristics and in Columns 2 KF and one characteristic. Is there any problem?

Regards, Federico