Dynamic Table Constructs

Add dynamic behaviour to a table using dynamic table columns constructs to discard column or set of columns at runtime.

Dynamic table columns

Discard a column or set of columns in a table from the final generated document as follows :

• Discard column if empty.
• Discard column if condition evaluates to true.

Discard column if empty

Column in a table can be discarded if every element of an array in the input json is empty or null.

How to use
Add discard-if-empty construct with boolean false/true along with the template tag to activate discard if empty feature for the corresponding column.

JSON representation of the input data:

Json 1

{
  "Project": [
    {
      "Name": "ABC Infra",
      "Milestone": "First Milestone",
      "DateComplete": "24/06/2021",
      "Notes": ""
    },
    {
      "Name": "ABC Infra",
      "Milestone": "Second Milestone",
      "DateComplete": "24/06/2022",
      "Notes": ""
    },
    {
      "Name": "DEF Computer Labs",
      "Milestone": "First Milestone",
      "DateComplete": "12/12/2021",
      "Notes": ""
    },
    {
      "Name": "DEF Computer Labs",
      "Milestone": "Second Milestone",
      "DateComplete": "12/12/2021",
      "Notes": ""
    }
  ]
}
CopyCopied to your clipboard
1{
2  "Project": [
3    {
4      "Name": "ABC Infra",
5      "Milestone": "First Milestone",
6      "DateComplete": "24/06/2021",
7      "Notes": ""
8    },
9    {
10      "Name": "ABC Infra",
11      "Milestone": "Second Milestone",
12      "DateComplete": "24/06/2022",
13      "Notes": ""
14    },
15    {
16      "Name": "DEF Computer Labs",
17      "Milestone": "First Milestone",
18      "DateComplete": "12/12/2021",
19      "Notes": ""
20    },
21    {
22      "Name": "DEF Computer Labs",
23      "Milestone": "Second Milestone",
24      "DateComplete": "12/12/2021",
25      "Notes": ""
26    }
27  ]
28}

Json2

{
  "Project": [
    {
      "Name": "ABC Infra",
      "Milestone": "First Milestone",
      "DateComplete": "24/06/2021"
    },
    {
      "Name": "ABC Infra",
      "Milestone": "Second Milestone",
      "DateComplete": "24/06/2022"
    },
    {
      "Name": "DEF Computer Labs",
      "Milestone": "First Milestone",
      "DateComplete": "12/12/2021"
    },
    {
      "Name": "DEF Computer Labs",
      "Milestone": "Second Milestone",
      "DateComplete": "12/12/2021"
    }
  ]
}
CopyCopied to your clipboard
1{
2  "Project": [
3    {
4      "Name": "ABC Infra",
5      "Milestone": "First Milestone",
6      "DateComplete": "24/06/2021"
7    },
8    {
9      "Name": "ABC Infra",
10      "Milestone": "Second Milestone",
11      "DateComplete": "24/06/2022"
12    },
13    {
14      "Name": "DEF Computer Labs",
15      "Milestone": "First Milestone",
16      "DateComplete": "12/12/2021"
17    },
18    {
19      "Name": "DEF Computer Labs",
20      "Milestone": "Second Milestone",
21      "DateComplete": "12/12/2021"
22    }
23  ]
24}

• {{Project.Notes:discard_if_empty(true)}} tag lets the engine discard the particular column if every element of an array in the input json is either empty or null.

Note: The row above the authored row will be considered as a header row. Cell from the header row will be discarded along with discarded column.

Discard column if condition evaluates to true

Column in the table can be discarded If condition provided in the discard-if(expr(condition)) evaluates to true. Add discard-if(expr(condition)) construct along with the template tag to activate discard if feature for the corresponding column.

JSON representation of the input data:

{
  "Conversion": [
    {
      "Month": "July, 2021",
      "Rate": 10,
      "Method": "Payout by Cheque"
    },
    {
      "Month": "September, 2021",
      "Rate": 30,
      "Method": "Payout by Cheque"
    },
    {
      "Month": "Dec, 2021",
      "Rate": 20,
      "Method": "Payout by Cheque"
    },
    {
      "Month": "April, 2022",
      "Rate": 20,
      "Method": "Payout by Cheque"
    },
    {
      "Month": "Dec, 2022",
      "Rate": 30,
      "Method": "Payout by Cheque"
    }
  ]
}
CopyCopied to your clipboard
1{
2  "Conversion": [
3    {
4      "Month": "July, 2021",
5      "Rate": 10,
6      "Method": "Payout by Cheque"
7    },
8    {
9      "Month": "September, 2021",
10      "Rate": 30,
11      "Method": "Payout by Cheque"
12    },
13    {
14      "Month": "Dec, 2021",
15      "Rate": 20,
16      "Method": "Payout by Cheque"
17    },
18    {
19      "Month": "April, 2022",
20      "Rate": 20,
21      "Method": "Payout by Cheque"
22    },
23    {
24      "Month": "Dec, 2022",
25      "Rate": 30,
26      "Method": "Payout by Cheque"
27    }
28  ]
29}

• {{Conversion.Rate:discard-if(expr($sum(Conversion.Rate)!= 100))}}% tag lets the engine discard the particular column if condition provided in the expr construct evaluates to true.