How to make Single QVD?

[siva_boggarapu]

Hi All,

Please look at the document and I have two sheets 3 months and 12 months sheet.

I need combine data columns in 3 months sheet and 12 months sheets.

Columns starts from 3 months sheet  ShoID, Repair Facility....

Columns starts from 12 months sheet ShoID, Repair Facility....

I want to combine them into one single QVD. There is no time stamp both sheets. How should I combine them into one QVD?

Thaks,

Siva

[YoussefBelloum]

Hi,

As I said above, your file need transformation before going to the concatenation part, you have merged cells and other excel things. My computer crashed because of it.

you should have structure like this:

dimension1	dimension2	dimensionN	Measure1	Measure2
value	value	value	value	value
value	value	value	value	value
value	value	value	value	value