Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Unpivot using wrong ID 2 months 19 hours ago #19925

  • HarryK
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 16
  • Thank you received: 1
Unpivot transform does not retain the correct ID when passed through.

I expected to see the text fields associated with the IDs as indicated in the value of the column, but this is not retained when passed through the unpivot.

DF, source and resulting data attached.

Application Name: Advanced ETL Processor Professional
Version number: 6.3.6.11
Operation system version: Windows 10 Pro v1909
Database version: MS Sql Server 2017 14.0.2027
Repository type: Database
Attachments:
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Unpivot using wrong ID 2 months 18 hours ago #19926

I think you are confused about how unpivot actually works.
This is understandable I am confused myself quite often.
Your data does not have any groups

Please read the following article.
www.etl-tools.com/wiki/aetle/processing_...working_with_unpivot
Peter Jonson
Support Analist
The following user(s) said Thank You: HarryK

Please Log in or Create an account to join the conversation.

Unpivot using wrong ID 2 months 17 hours ago #19927

I have updated the pictures so they are more clear and less confusing
The following user(s) said Thank You: HarryK

Please Log in or Create an account to join the conversation.

Unpivot using wrong ID 2 months 17 hours ago #19928

  • HarryK
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 16
  • Thank you received: 1
That makes much more sense now.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 166 guests and one member online