​​​​Ed Orlando​

Dynamic Union

​

Use Case:

We received some data that do not have the columns aligned in the same order.  The columns and the data need to be organized in the following order:

​

   1. Column A

   2. Column B

   3. Column C

   4. Column D

​

​

Data Set #1                                        Data Set #2 (Header Lookup)   

 

 

 

 

 

 

 

 

 

 

Final Output

 

 

 

 

 

Workflow with Detail