XER Transform : Transform XER files via pivots, unpivots, and joins

• Tool Description
  Transform XER files by pivotting, unpivoting, and joining tables for easier usage in other tools (Excel, PowerBI, etc.)
  
  For example, you can join the TASK table with PROJECT and CALENDAR tables effeciently with this tool without relying on SQL or Excel.
  
  Or you can unpivot specific columns from the XER such as 'Target Start Date' and 'Target End Date' such that the data row exists twice, but with two additional columns: one to indicate the header ('Target Start Date' or 'Target Start Date'), and the other to indicate the respective value.
• Required Input
  One or more Oracle Primavera XER files. The selected transformation will be processed against all files in the same manner.
• Optional Output
  An tab-delimited txt file with the table output; for easy usage in third party tools.
• User Advice
  None planned at this time.