Alpha DevCon 2018
Results 1 to 4 of 4

Thread: Convert rows into column

  1. #1
    Member
    Real Name
    Leif Erik Buroe
    Join Date
    Dec 2009
    Location
    Norway
    Posts
    45

    Default Convert rows into column

    Hi
    First I want to say thank you to Alpha5, excellent product.

    I think some useful thing will be, to have the option to convert rows into column and opposite,
    and view this in grid, and be able to export this to Excel (must be Dynamic)

    BR
    Leif Erik Buroe

  2. #2
    Member
    Real Name
    Roger Noguera
    Join Date
    Jul 2010
    Location
    Sant Cugat del Vall├Ęs
    Posts
    232

    Default Re: Convert rows into column

    SQL servers do this. At least Microsoft SQL servers.
    You should use the PIVOT instructions.

    Then you can display the data inside Alpha5.

    I am using this type of transformation with Alpha5 without major trouble.

    Of course having native support for the pivot would probably be more powerful....

  3. #3
    Member
    Real Name
    Leif Erik Buroe
    Join Date
    Dec 2009
    Location
    Norway
    Posts
    45

    Default Re: Convert rows into column

    Hi
    Thank you for your input, yes I have done some research for SQL,
    I was hoping A5 want to implement this V11?

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,992

    Default Re: Convert rows into column

    Created a function some time ago to transpose a table and create a new table from it. Not built in but functional.

Similar Threads

  1. Rows of Data vs. Maximum # rows per page
    By bjacobson in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 05-19-2011, 04:10 PM
  2. Rows of Data vs. Maximum # rows per page
    By bjacobson in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 05-19-2011, 01:35 PM
  3. New Quick Sort Column click & moving column
    By dchiass in forum Alpha Five Version 8
    Replies: 0
    Last Post: 05-28-2007, 08:07 PM
  4. rows and column
    By chunyang in forum Alpha Five Version 7
    Replies: 1
    Last Post: 05-05-2006, 05:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •