Data Shuttle not adding entries
I'm coming here for help. I'm currently trying to combine about 33 excel sheets into one file using data shuttle. Now the issue is that I might have as many as 3-5 people working on the same project. However, when I try to load the data, if the project code is already there, it does not add entries with the same project code from other sheets.
Is there some kind of workaround that will let me load multiple same project IDs in?
I was thinking of Auto-Number column, but Shuttle doesn't let me use that as a unique ID column.
Below is my standard setting: