topic Re: merge data in QlikView

merge data

userid128223 — Sat, 15 Mar 2014 04:51:22 GMT

I have master qvd like below.

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

1 dfd

1 dfdgd

1 dfdfd

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

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

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

nagaiank — Sat, 15 Mar 2014 04:57:35 GMT

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 — Sat, 15 Mar 2014 07:25:23 GMT

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

PrashantSangle — Sat, 15 Mar 2014 07:30:37 GMT

Hi,

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

Regards,

jagan — Sat, 15 Mar 2014 07:54:50 GMT

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.