Profile picture for user mrei

Hi everybody,

i am wondering if it is possible to transpone single values of one column (from data feed) to many new columns?

Requirement:

- Column of data feed (PRODUCT) has the values: A, B, C

- Rows (with No. of products) looking like:

PRODUCT     |     #     |        ID

  • A              |     23   |     4711
  • A              |     14   |     4712
  • A              |       3   |     4713
  • B              |     10   |     4714
  • B              |     20   |     4715
  • B              |     20   |     4716
  • C              |       2   |     4717
  • C              |       4   |     4718
  • C              |       4   |     4719

- Now, i would like to transpone it like in XLS to:

            A     |     B     |     C     |     ID

  •    23          0           0          4711
  •    14          0           0          4712
  •      3          0           0          4713
  •      0         10           0          4714
  •      0         20           0          4715
  •      0         20           0          4716
  • etc.

Thanks for any idea or response if possible or not anyway.

Rgds, Martin

by dario borsotti
Posted on Thu, 06/09/2011 - 12:11

look for "transpose" or cross-table, you will find some interesting ideas.

 

 

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock