Solved

Rows to Columns

  • 1 March 2022
  • 1 reply
  • 83 views

Badge

I was wondering if there is a way in Ataccama that I can move my rows data into columns?

I’ve data as such:

Element:          Dimension:                 Values:         Code:

 XYZ            Validity                        200               678

XYZ            Completeness              250               678

 YUP            Completeness            300                555

 HIO             Accuracy                     400                100

 

I’d like it to look like:

Element:          Validity:                 Completeness:        Accuracy;         Code:

 XYZ                 200                               250                         250               678

 YUP                500                                300                        300                555

 HIO                 200                                450                        400                100

 

Thank you!

 

 

icon

Best answer by tombolek 2 March 2022, 05:35

View original

1 reply

@anu1237 I think this is something you should be able to do with the Representative Creator step in a plan. I’m sure that there are other steps such as Group Aggregator that may work as well, but Representative Creator is the one I like.

You’re “Group By” will be the element column:

 

For each of your resulting columns such as Validity or Completeness, you’ll create a group of new “Representative Attributes” and select the best value:

 

The selection criteria for best is then that the record contains the correct dimension:

 

Reply