Author Topic: Merging multiple records in a single record for use with Excel  (Read 2780 times)

Offline Yavga

  • Associate
  • **
  • Join Date: May 2014
  • Posts: 2
  • Forum Citizenship: +0/-0


I'm having a situation, where I have to combine multiple record data into a single record/cell
Column 'Memo' contains textual data between 4-10 lines/records text.
each set of multiple records contains a label called 'Code'

I am trying to get these 4-10 lines of Memo into a single record per Code.

For archiving purposes this data needs to be stored in an already existing excel sheet.

I cannot figure out wherether this is possible, I have already tried creating complex formulea within Impromptu, to no avial.
Is there anyone willing to think with me?


Offline ianderson

  • Full Member
  • ***
  • Join Date: Jun 2009
  • Posts: 15
  • Forum Citizenship: +1/-0
Re: Merging multiple records in a single record for use with Excel
« Reply #1 on: 08 May 2014 06:36:15 am »
Is there a line number field in the Memo table? like 1 to 10 ?

If so, alias the table 10 times in the catalog, and in the join for each as well as what the join should be add ' and <line number field> = 1', 'and <line number field> = 2' etc for each of the 10 tables.

You'll then have 10 separate memo folders in the catalog - add the 10 memo fields to your report and you'll have them all in one row rather than over multiple rows. You should then be able to add them together to get them all in one 'cell'.

If there isn't a line number in the table, or you don't have access to the catalog, you could probably achieve the same result by adding a line number to your report, saving it, and then using it as a hotfile (mulitple hotfiles) in a report to achieve the same linkage in the report filter, rather than the catalog joins. (But the catalog is probably the easier option).

Hope this helps.

Offline Yavga

  • Associate
  • **
  • Join Date: May 2014
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Merging multiple records in a single record for use with Excel
« Reply #2 on: 09 May 2014 03:07:00 am »
I will try your method, thanks for the effort!

 


       
Twittear