RE: recursive values
Mr. Raven,
Did you find an answer?
I'll bet we can do what you're asking, but like other responders, I need
a few more details.
Off the cuff:
NAME.ADDR.CITY.CSV
01: I
02: CATS( CATS( REUSE( '"':NAME:'","' ),STREET),
REUSE('","':CITY:'"'))
Then
SELECT file . . . SAVING NAME.ADDR.CITY.CSV
SAVE.LIST [optional_somewhere] reportname.CSV
now you have a comma-delimited flat file ready to import to a
spreadsheet.
But I'm guessing at data structure & what you want to achieve.
Chuck Stevenson
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Raven
> Sent: Friday, February 20, 2004 11:03 AM
>
> I am using Universe and am looking for a way to have
> recursive values in my retrieve report. I would like to export
> this report to a spreadsheet.
>
> The pick command for a dictionary would be LPV (last previous
> value) and I have tried TRANSPORT.
>
> report
>
> name... street ... city
> Raven 1234 IRVINE
> A STREET
>
>
> Would like this
> name... street ... city
> Raven 1234 IRVINE
> Raven A STREET IRVINE
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE BY.EXP STREET would separate your MV'd street field unacceptably. A quick & dirty would be to create I-Types for your "name" and "city" fields, each of which would DCOUNT the values in "street" and construct a MV'd repeating list of the name/city with a matching number of values. Make sure the new I-Types are defined as "M"ultivalued, and this should give you the output you are looking for. Jim -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
Did you tried with the REUSE en the dictionary ? -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Dave Raven Enviado el: viernes, 20 de febrero de 2004 13:03 Para: [EMAIL PROTECTED] Asunto: recursive values I am using Universe and am looking for a way to have recursive values in my retrive report. I would like to export this report to a spreadsheet. The pick command for a dictonary would be LPV (last previous value) and I have tried TRANSPORT. report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE Dave R P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
You mean repeating values. You have BY-EXP don't you? From: [EMAIL PROTECTED] on behalf of Dave Raven Sent: Fri 2/20/2004 2:03 PM To: [EMAIL PROTECTED] Subject: recursive values I am using Universe and am looking for a way to have recursive values in my retrive report. I would like to export this report to a spreadsheet. The pick command for a dictonary would be LPV (last previous value) and I have tried TRANSPORT. report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE Dave R P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
is this one record or two records ? Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
recursive values
I am using Universe and am looking for a way to have recursive values in my retrive report. I would like to export this report to a spreadsheet. The pick command for a dictonary would be LPV (last previous value) and I have tried TRANSPORT. report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE Dave R P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
