Hi. I'm having an issue with the Union Tool having no output if any one of its inputs is completely non-existent.
This is my scenario:
Any advice would be much appreciated. Thanks a lot! 😊
Solved! Go to Solution.
Hey @Peachyco, how is your union configured? Some of the configurations (such as Output a Common Subset of Fields) rely on the 2 schema being identical which wouldn’t be the case if you have a blank output from the Dynamic Rename.
EDIT: Realise this wouldn't work, sorry.
The below should do what you're looking for - all you need is a lookup table (going into the right hand side of the join) with what the correct headers should be (in order) - all it does is transpose your current headers, assign their position and then match that position against your lookup table before renaming them as required. If your headers are already correct, they'll be maintained. If they're incorrect, they'll be changed:
@Peachyco, can you provide us a sample input and output of the requirement if possible?
Thanks!
@DataNath : Thanks a lot for the advice! 😊 While it's not the complete solution, the principle/design behind your proposed solution served as the foundation for the solution that I eventually ended up with.
So, instead of introducing a fork in the road - with one path performing the Dynamic Rename - and then using Union to bring those paths together again, I now have just a single path that goes through the Dynamic Rename, changing the column names only when necessary.