Combining sheets with diff schema and certain columns not duplicating

[Hi2023]

How do I combine 4 sheets from 1 excel report together but account_details and subject_details sheet only want the account# and # listed once in joined excel report since it is listed in both these sheets?

thanks

[nduan]

Here's how I did it:

I brought in 2 input tools, 1 for the Account details sheet, 1 for the Subject details sheet, and removed the "extra" field in the Join itself. I have attached a sample workflow. 

[gabrielvilella]

Hi, here is how I did this.

[Kinga]

hi @Hi2023 

Your issue sound very similar to challenge 118 from weekly challenges: Challenge #118: Think Like a CSE - A not-so-wild-w... - Page 10 - Alteryx Community

You could try some of users solution from there

[Hi2023]

What if I am using a directory tool to pull since its several files and a batch macro---

[gabrielvilella]

My solution has the directory tool and batch macro to read the files.

[Hi2023]

and it wont let me open due to newer versionnnnnnnnnnnn😭

[gabrielvilella]

If you just click Yes on that message it should open it. I saved a new one that is not an app.

[Hi2023]

it usually does after but it doesnt open yours

[gabrielvilella]

See if you can open this.