SearchPane count rows instead of cells

Supervolcano

First time caller, Long time listener!!

Real table is 144 columns x 7500 rows using between 9-25 searchPanes on each page.

https://live.datatables.net/nohorelu/1/edit/

I am a international freight forwarding company wanting to merge 3 columns of company names (shipper, consignee, bill_to) into 1 extra searchPane counting total rows where each name exists instead of total cells. One company could be listed as all 3 parties (shipper, consignee, bill_to).

                        "render": function (data, type, row) {
                            if (type === 'sp') {
                                return [row.name, row.position, row.office];
                            }
                            return data;
                        }

In this basic example, I need Edinburg to result with 7 instead of 12.

I realize a search filter is ideal, but I want this custom pane to look & act the same as the rest of my searchPanes.

kthorngren

Will converting the array into a set of unique items do what you want? For example:

https://live.datatables.net/nohorelu/2/edit

Kevin

Supervolcano

Beautiful, you guys truly are amazing!