You must merge the data into a single consolidated source prior to loading.
You can not make relational links during a load.
--
HTH...

Jim Thomlinson


"Nelson" wrote:

I have 2 streams of data I need to pull into one pivot table, they can be
mapped together by a customer number

How can I go about pulling the data down then merging them to one pivot table?

Thanks
--
Nelson