Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have you looked at this? The Crosstable Load
thanks but i dont think the cross table function will do what i need.
Why not?
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!