+2I 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
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:
+1You’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:
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
