• EN
Solved

"None" rows in HTMLReportGenerator table when those rows shouldn't exist

  • 7 November 2019
  • 2 replies
  • 17 views
R

Hi all.

This is occuring on FME Workbench 2019.1.

I'm using an HTMLReportGenerator to create a table that should have 10 rows. However, I get the 10 expected rows, plus many more that simply say "None." (see attached photo).

 

The 10 features come from a SQLExecutor and I've checked the output with an inspector and have confirmed that there are only 10 rows. The HTMLReportGenerator output isn't very telling, but here's a snippet of where the "None" values begin:

 

            <tr>
               <td>Point Loma</td>
               <td>108</td>
            </tr>
            <tr>
               <td>None</td>
               <td>None</td>
            </tr>

I've tried replacing all instances of

<tr>               <td>None</td>               <td>None</td>            </tr>

with empty space but that didn't change anything.

 

How can I completely remove these rows from the table?

 

Example photo:

0684Q00000ArET0QAN.png

icon

Best answer by rwardrup 7 November 2019, 20:51

View original

2 replies

daveatsafe
Rank
Userlevel 2
Badge +17

Hi @rwardrup,

When you run the workspace within Workbench, how many input features do you have entering the HTMLReportGenerator?

R
I figured it out. I had two transformers feeding into the HTMLReportGenerator. For some reason, the HTMLReportGenerator was generating table rows for the map data, and not just the actual rows that should be in the table.

 

I created another HTMLReportGenerator for the map data, and fed both of them into an HTMLLayoutter, and all is well.

Reply


Community Stats

28,869
Posts
109,984
Replies
36,672
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.