generate->table datas missing with join request

What does the data look like when you run the query elsewhere, or use print_r($query->result())? It would also be helpful to see the HTML for the generated table (copied from View Source in the browser), rather than a picture of the table.

If you want people to export the library in Excel, you may want to use a library to generate an xlsx or csv file rather than going through the trouble of generating an HTML table.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide