Skip to main content
Solved

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


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

Best answer by rwardrup

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.

View original
Did this help you find an answer to your question?

2 replies

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • November 7, 2019

Hi @rwardrup,

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


  • Author
  • Best Answer
  • November 7, 2019
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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings