Asle Frantzen

AF: Return multiple Table Lookup values and concatenate them as a string?

Discussion created by Asle Frantzen Champion on Sep 3, 2012
Latest reply on Sep 4, 2012 by Asle Frantzen

Hi guys


I'm filling data into AF by doing a lookup into an Oracle database (through AFTables).


All my lookups so far have been with a unique identifier, but now I'm faced with the challenge of returning a concatenated string of all results returned by a query. The case is a faults table where all the faults of the different equipment are stored. Next to the amount of faults they also want to see the years of each fault, so if the number of faults is 3, they want to see the following in the report I'm making:

  • 3 (1992, 1997, 2003)
  • 1 (2002)
  • 2 (1992, 1993)

If I do a simple lookup having the attribute data type as 'string' I will only get the first result. If I change the data type to 'string array' I will get all the results, but then I can't utilize the results further on through OLEDB Enterprise. If only there was an array.tostring() function somewhere.


Any tips or tricks on how to achieve this?