1[% USE CSV -%] 2[% CSV.dump([ 'VLAN' 'Device' 'Description' 'Ports' 'Model' 'OS' 'Vendor' ]) %] 3 4[% FOREACH row IN results %] 5 [% mylist = [] %] 6 [% device = row.dns || row.ip %] 7 [% FOREACH col IN [ row.vlans.vlan device row.vlans.description row.pcount row.model row.os row.vendor ] %] 8 [% mylist.push(col) %] 9 [% END %] 10 [% CSV.dump(mylist) %] 11 12[% END %] 13