Excel aggregating function based on an attribute/field

[Saya22]

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,


<code style="margin: 0px; padding: 0px; font-style: inherit;">CREATE TABLE WEBLOG_AGG ASSELECT C_IP,tab_to_string(CAST(COLLECT(WEB_LINK) AS T_VARCHAR2_TAB)) AS WEBLINKSFROM WEBLOG_SESSIONGROUP BY C_IP;</code></pre>

 

[jeffreybrown]

X-Post

 

[Saya22]

X-Post

Any idea on how I can edit the post here?

 

[jeffreybrown]

There is a time limit for making edits, and if expired, you will now have to ask a moderator to edit your post.

Reading and Posting Messages

If you click the little triangle below your name in this thread you can report the post with your requested changes, but I can do it for you here.

Cross-posts:

Excel aggregating function based on an attribute/field

User user1888543 - Stack Overflow

Excel aggregating function based on an attribute/field