How to merge multiple columns in a report | Community
Skip to main content
A
AudraSc
October 25, 2024
Question

How to merge multiple columns in a report

  • October 25, 2024
  • 2 replies
  • 1003 views

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
October 28, 2024

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!

    Sven-iX
    Community Advisor
    Sven-iXCommunity Advisor
    Community Advisor
    October 28, 2024

    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

    Srinija_N
    Srinija_N
    Level 7
    October 28, 2024

    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

    Terms & ConditionsAccessibility statement

    Loading footer...