Group Certain Fields in Table into 1 Field within the table

[wonkymeister]

Hi,

I have a single table of finance data that contains multiple fields and for display purposes I’d like to group 6 of the fields from the table into 1 single field in order that I can display the 6 fields in one table as 1 dimension with an additional column as actuals(the expression).

I.e.

Finance_Table:

Actual,

Budget,

Group1_code,

Group2_code,

Group3_code,

Field1_to_combine,

Field2_to_combine,

Field3_to_combine,

Field4_to_combine,

Field5_to_combine,

Field6_to_combine,

Financial_year,

Financial_period,

Etc

how can i logically group Field1_to_combine, Field2_to_combine, Field3_to_combine, Field4_to_combine, Field5_to_combine, Field6_to_combine into 1 field in the table? I thought of concatenating them as a resident load? Some way to remodel the fields in the load script?

any ideas/thoughts greatly appreciated.

[sunny_talwar]

Have you looked at this? The Crosstable Load

[wonkymeister]

thanks but i dont think the cross table function will do what i need. 

[sunny_talwar]

Why not?

[andrei_delta]

hi,

example for group_code:

if ( len(Group1_code)>0,

              Group1_code,

              if( len(Group2_code)>0,

                            Group2_code,

                             if(len(Group3_code)>0,Group3_code))) as GroupCode

concatenate it's an alternative but i wouldn't use it in your case.

hope it helps!