Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator III
Creator III

Group Certain Fields in Table into 1 Field within the table

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.

 

4 Replies
sunny_talwar

Have you looked at this? The Crosstable Load

wonkymeister
Creator III
Creator III
Author

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

sunny_talwar

Why not?

andrei_delta
Partner - Creator III
Partner - Creator III

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!