merge data

[userid128223]

     I have master qvd like below.

id     name     amount 2012-01     2012-02     2012-03

1     dfd

1     dfdgd    

1     dfdfd

2

2

2

I have seperate excel sheet with uniq id for each entire year

id      name     amount     2014-01     2014-02 ....

2

2

how can merge each excel sheet with id to merge with master.

final results should look like

id     name     amount 2012-01     2012-02     2012-03      2014-01     2014-02

1     dfd

1     dfdgd    

1     dfdfd

2

2

2

[nagaiank]

You may load the yearly files using crosstable load.

Concatenate the files.

Generate a pivot chart from the combined file to get the desired result.

[Colin-Albert]

The crosstable function should be used in your load script to unpivot the data as you load it.

You can see some examples here. How do I convert columns of data into rows - using QV Script

[PrashantSangle]

Hi,

You can use concatenate or left join on table in script.

Regards,

[jagan]

Hi,

Try like this

Data:

Crosstable(Month, Value, 2)

LOAD

*

FROM Master.qvd;

Concatenate(Data)

Crosstable(Month, Value, 2)

LOAD

*

FROM Master.xls;

Regards,

Jagan.