How to group 2 columns into 1???

[jsingh71]

I have a table like this

Planned	Holiday	Vacation
6	1	5
10	3	7
20	6	14
7	2	5
11	3	8
22	7	15
8	3	5
18	6	12

Now I want to Group 'Holiday' and 'Vacation' Under 'Planned'

[#2]

Didn't get your question.

Can ypu please elaborate what is it that you are trying to accomplish

Regards

Mhatim

[its_anandrjs]

In a load script create a field like

Holiday+Vacation as NewPlanned

But what is requirement for this and meaning of Group 'Holiday' and 'Vacation' Under 'Planned'

Regards,

Anand

[jagannalla]

Hello,

Try this:

Main:

Load RowNo() as Key,

Planned as P,

Holiday as H,

Vacation as V

From Main.qvd;

Res_Main:

Load Key, P as Planned Resident Main;

Load Key, H as Planned Resident Main;

Load Key, V as Planned Resident Main;

Hope it helps you..

Cheers!!

Jagan

[jagan]

Hi,

Try this script

TableName:

Load

     Planned AS Dimension,    

     'Planned' AS Type

FROM DataSource;

Concatenate(TableName)

Load    

     Holiday AS Dimension,

     'Holiday' AS Type

FROM DataSource;

Concatenate(TableName)

Load    

     Vacation AS Dimension,

     'Vacation' AS Type

FROM DataSource;

Hope this helps you.

Regards,

Jagan.