Skip to main content
Solved

Rows to Columns

  • March 1, 2022
  • 1 reply
  • 124 views
A
Data Voyager
Forum|alt.badge.img+2

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!

 

 

Best answer by tombolek

@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:

 

1 reply

T
Ataccamer
Forum|alt.badge.img+1
  • tombolekAtaccamer
  • Ataccamer
  • 3 replies
  • Answer
  • March 2, 2022

@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:

 


Community Terms of Use & ConditionsCookie settingsAccessibility statement