Combining Two Text Columns into one column with Custom Formatting in Inforiver

Using Inforiver, a powerful reporting and analytics tool inside Power BI, to manage and visualize your data. You have a two data input columns text columns, and you want to combine these columns into a single output column. Additionally, you want to apply specific formatting to the resulting combined column using Inforiver’s table functions.

The table function converts each cell inside Inforiver report as Table where you can customize according to your needs

Key Functions:

1. TABLE:

   • The outermost function, used to wrap and create a table structure containing multiple rows.

   • Inside the table, rows and cells are defined using TABLEROW and TABLECELL respectively.

2. TABLEROW:

   • Defines a single row within the table.

   • Each TABLEROW contains one or more TABLECELL elements that define individual cells for that row.

3. TABLECELL:

   • Represents the content inside each cell in a table row.

   • The arguments passed to this function typically define the text or value inside the cell, formatting properties (such as font weight or alignment), and various other options like text wrapping or overflow behavior.

     
     Please find the sample code below:

     TABLE(

      TABLEROW(

          TABLECELL("Sigin",30,'',   {"fontWeight":'bold'}),

           TABLECELL( [TEXT],0,'RIGHT'),{"overflow":'visible',"text-wrap":'wrap',"overflow-wrap":'break-word'})

      ,

     TABLEROW(

        TABLECELL("Signout",30,'',{"fontWeight":'bold'}),

         TABLECELL( [TEXT2],0,'RIGHT',{"overflow":'visible',"text-wrap":'wrap'}))

     )

     Sample output below with the output column named New measure:
     

     

     This use case demonstrates how to combine two text columns into a single column using the Table Functions in Inforiver.. Additionally, it shows how to apply custom formatting, such as bolding part of the text, directly within the result column. Inforiver's flexibility allows users to manage data transformations and visual presentation with ease.