apply template to location and job tabular data