Associating multiple columns from 2 excel files

[JoannaManibo]

I'm trying to associate multiple columns from 2 excel files. See the sample data below:

1st Excel File:

Location:

qwe

rty

uio

Team:

Team A

Team B

Team C

2nd Excel File:

Location:

qwe

rty

uio

Team:

Team A

Team B

Team C

What I'm trying to do is I associate Location from 1st Excel and Location from 2nd Excel. Right after I associate the first group, I tried the next one which is Team from 1st Excel and Team from 2nd Excel. But every time I try to associate the 2nd group, the Location from 2 excel files are reverting to its original naming.  

[mfarsln · Accepted solution]

Hi,

You can create key column to associate more than one column. 

AutoNumber(Location & Team) as Key

Add this to both of your excel file's load script.  This will allow you to associate two tables with two columns.