Jump to content
Sign in to follow this  
mweiss

Summarize data by concatenating value of specified field across all records?

Recommended Posts

The subject heading may be obscure... I have a table with a text field -- let's call it Table::t_Words. I want to define a field that will take all values of Table::t_Words for the current found set and concatenate them (in their current sort order). Sort of a summary field, but instead of adding or averaging numbers, it concatenates text. Can such a thing be defined? Some clever calculation, perhaps, involving value lists? Does anybody have any ideas?

Share this post


Link to post
Share on other sites

Well... you can just do a script I suppose. I can think of the beginnings of a CF to do this... but really, in this case, you'll really want a looping script, I think.

Share this post


Link to post
Share on other sites

If you can create a relationship, you could create a value list on the related table and use the ValueListItems function, which "Returns a list of the values in valuelist, separated by carriage returns."

David

Share this post


Link to post
Share on other sites

Currently I use a looping script, but I'd like something that updates automatically, without having to be executed by the user.

I thought of the self-join --> value list --> replace line-breaks with spaces calculation, and it worked, sort of, but it automatically sorts the words in alphabetical order, rather than preserving the current sort order.

I guess I'll stick with my script for now. ???

Share this post


Link to post
Share on other sites

Wouldn't it just be substitute( list( relation::textField); "¶"; " ")

Edited by Guest

Share this post


Link to post
Share on other sites

Not if you want to get the found set (and not in version 8). You need a custom function for this, something like:

ListFoundSet ( fieldName ; startRecord ; endRecord )

Let ( [

item = GetNthRecord ( fieldName ; startRecord )

] ;

Case ( not IsEmpty ( item ) ; item & ¶ )

&

Case ( endRecord > startRecord ; ListFoundSet ( fieldName ; startRecord + 1 ; endRecord ) )

)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.