Results 1 to 8 of 8

Excel aggregating function based on an attribute/field

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Excel aggregating function based on an attribute/field

    I've got an excel file with columns,

    C_IP
    SESSION_ID
    CS_USER_AGENT
    CS_URI_STEM
    CS_URI_QUERY
    WEB_LINK

    I'm not able to aggregate the above attributes due to the limitations of the string size allowed in Oracle (11g). I tried to use a user-defined aggregating function for this. I want to aggregate the "WEB_LINK" column, and group by C_IP. Is it possible to do this in Excel?

    The SQL query I tried to use was,

    CREATE TABLE WEBLOG_AGG AS
    SELECT C_IP,
    tab_to_string(CAST(COLLECT(WEB_LINK) AS T_VARCHAR2_TAB)) AS WEBLINKS
    FROM WEBLOG_SESSION
    GROUP BY C_IP;

    Cross-posts:

    http://www.mrexcel.com/forum/excel-q...ml#post3345639

    http://stackoverflow.com/users/18885...?tab=questions

    http://www.excelguru.ca/forums/showt...=5973#post5973
    Last edited by Saya22; 12-19-2012 at 12:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1