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
Solved! Go to Solution.
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
What if I am using a directory tool to pull since its several files and a batch macro---
My solution has the directory tool and batch macro to read the files.
and it wont let me open due to newer versionnnnnnnnnnnn😭
it usually does after but it doesnt open yours