13 Replies Latest reply on Mar 11, 2016 7:46 AM by Ajo Abraham

    Data blending Zip codes performance issue

    dipesh.patel.4

      I am looking for the best / most efficient way to blend or join a secondary data source which contains a master zip to territory mapping.

       

      Primary data source: (live connection tableau online) each row has a zip

      Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory

       

      I am looking to add the territories from the master zip to territory file as a filter.

       

      I tried data blending using the zip codes as a common field but I am facing very slow performance.

       

      Is there a better way to do this?