Option to Auto Populate Column list in Union Transformation

Hellos,

If both the sources have same columns name , it makes sense to have a button to auto generate columns list (from both sources) including Output Field Name

Unless this already exists and I am missing it, please guide me towards this 

I know I can create in EXCEL and import inside , but this again is many extra step for the user. (I need to copy headers to excel , transpose , add brackets to replicate structure , then copy and paste) instead If I have a button which can match existing headers !

Cheers,
PM

 

As requested we have added Auto map button to Union All Dialogue 

HI Peter,
Thanks for this , 1/3rd work done , at-least all(most) outputs are mapped. 

How do we get the best result with this ? see case below where after pressing the automap , it mapped output field correctly but none(few) of the fields got mapped from files.

1. I assume it's looking at ascending order and trying to match also in the same way in source files ? It would be better if the field found is mapped saving user work.
2. I am also reporting a bug that source field 1 is not showing any drop down (consistently) .

I can send source files if needed via email or pm if you want to double check
 
 

I am also reporting a bug that source field 1 is not showing any drop down (consistently) .

I have reproduced the problem and will let you know once update is available


 

Also:

Automap  is case sensitive plus you might have spaces in field names.
That include spaces at the beginning and at the end of fields name
Plus you might have eol characters in field names

Please try the latest version and let us know the outcome