Topic Options
#24580 - 11/12/08 02:15 PM combining different data
rondejong Offline
Junior Member

Registered: 11/12/08
Posts: 2
Loc: Rotterdam
Hello all,

I have a question regarding multiple records. Hope I can make it a bit understandable, because english isn't my native language.

The following is the case: i have a xls-file in which there a number of rows that contain an id-number in a certain cell. When an id-number is used in, for instance row 3 to 8 (all in the same column), I have to print this particular id-number in one letter but with the other information from the row 3 to 8. Example: idnr 12345 is in row 1 to 5. In each of this rows there is another piece of info regarding that particular id-number but that info is in the same column (for example: in row 1 his age in column B, in row 2 his height in column B and so on). The goal is to print that id-number just one time in the lay-out and then the different pieces of info from the rows with that same id-umber.
Hope it is clear what I mean confused . I can't find a way for doing this, but i hope it is possible with PSM 6.

Thanks for any help!!!

ron

Top
#24581 - 11/14/08 01:22 PM Re: combining different data
Anonymous
Unregistered


Hi Rondejong,

I am not sure I fully understand your situation.

Do you mean that in a column you will have "customer number" for example. You will then have in a second column different informations that will be of a different type depending on which customer number row you are looking at. And you want to be able to grab all the different information located in column 2, that will all refer to the same customer number, but since they are on different rows, you cannot do it in PSM because it implies changing the record number.

If I got this right, well I think you will need to alter your database. Either changing the query, or creating a new table in which you will have all these informations in their own field for each customer number. Then using ODBC connection, you can load that table from PSM and map your document according to your needs.

Please clarify your needs if I am mistaken. I suggest you open a support call on our website so one of our technicians can help you find out the best way to achieve what you want to do. Thanks.

Regards,

Olivier

Top
#24582 - 11/18/08 06:30 AM Re: combining different data
rondejong Offline
Junior Member

Registered: 11/12/08
Posts: 2
Loc: Rotterdam
Hi Oliver,

Exactly what you describe is the kind of thing we needed to do. I also thought it cannot be done in PSM and because there was a limited time for us to achieve this, we had to give it to another company who could help us out with another program in which it could be done (Documate).

Thanks anyway for your reaction!!

Greets,
Ron

Top