Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

How to merge multiple columns in a report

Avatar

Level 1

I am trying to merge three columns of data into the same column with line breaks. The original Column 0 was Project Name, Column 1 was Project Reference Number and Column 3 was a custom field we call Project Code. I was able to successfully merge Columns 0 and 1 by inserting a new column between 0 and 1, pasting the below information into the new column and lastly pasting sharecol=true to column 0.

 

value=<br>

valueformat=HTML

width=1

sharecol=true

 

 When I try to repeat these steps to pull in the Project Code column, I'm having issues. I inserted a new column in between Project Name and and Project Code, pasted the below information into the new column and saved. I even tried adding column.3.sharecol=true to my now left most column and all it does is remove the header from the Project Code column without pulling over any information. 

 

value=<br>

valueformat=HTML

width=1

sharecol=true

 

Below is what my text looks like currently in the left most column

 

column.0.displayname=
column.0.linkedname=direct
column.0.namekey=name
column.0.querysort=name
column.0.sharecol=true
column.0.textmode=true
column.0.valuefield=name
column.0.valueformat=HTML
column.1.displayname=Column
column.1.sharecol=true
column.1.textmode=true
column.1.value=<br>
column.1.valueformat=HTML
column.1.width=1
column.2.displayname=
column.2.linkedname=direct
column.2.namekey=referenceNumber
column.2.querysort=referenceNumber
column.2.textmode=true
column.2.valuefield=referenceNumber
column.2.valueformat=int

 

And here is the text from the column I am trying to pull in (I haver some customizations for when the field is blank to insert N/A). 

 

valuefield=Project Code
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.operator=isblank
styledef.case.0.comparison.leftmethod=DE:Project Code
styledef.case.0.comparison.isrowcase=false
styledef.case.0.comparison.righttext=
styledef.case.0.comparison.lefttext=DE:Project Code
styledef.case.0.comparison.truetext=N/A
valueformat=customDataLabelsAsString
linkedname=direct
namekey=Project Code
textmode=true
querysort=DE:Project Code
case.0.comparison.truetext=N/A
case.0.comparison.righttext=
case.0.comparison.leftmethod=DE:Project Code
case.0.comparison.operatortype=string
case.0.comparison.isrowcase=false
case.0.comparison.icon=false
case.0.comparison.operator=isblank
case.0.comparison.lefttext=DE:Project Code

 

What do I need to add to these columns so they will merge together? 

3 Replies

Avatar

Community Advisor

if in the report you have 2 columns next to each other that you want to simply merge, you only need to include this in preceding column:

sharecol=true

so in your example it will be:

column.2.sharecol=true

once you save text code with this line, columns will merge.

 

Cheers!

Avatar

Level 6

To keep it simple, I merge from the right: That way all you add is "sharecol=true".

 

Per @Rafal_Bainie - you need to add the sharecol argument to the right-most column which in your case is column.2

Avatar

Level 4

Hi @AudraSc ,

Below is the text mode column which I built for one of reports for a user to merge multiple custom fields into one column of the report. Hope this helps!

 

column.7.displayname=COLUMN_NAME
column.7.sharecol=true
column.7.textmode=true
column.7.value=<strong><font color=#000000>Section_Name 1: </font></strong>
column.7.valueformat=HTML
column.8.displayname=Field1
column.8.linkedname=direct
column.8.namekey=Field 1
column.8.querysort=DE:Field1
column.8.sharecol=true
column.8.textmode=true
column.8.valuefield=Field1
column.8.valueformat=customDataLabelsAsString
column.9.displayname=Field2
column.9.sharecol=true
column.9.textmode=true
column.9.value=<br><strong><font color=#000000>Section_Name2: </font></strong>
column.9.valueformat=HTML
column.10.displayname=Field2
column.10.linkedname=direct
column.10.namekey=Field2
column.10.querysort=DE:Field2
column.10.textmode=true
column.10.valuefield=Field2
column.10.valueformat=customDataLabelsAsString