AnsweredAssumed Answered

Conversion from portal LineItems to one single row of fix fields

Question asked by Snoopy7 on Jun 28, 2015
Latest reply on Jul 7, 2015 by Snoopy7

Title

Conversion from portal LineItems to one single row of fix fields

Post

Hello

I have already a supporting table for preview of 3 portals, but need new table for Word export

Existing supporting table PRINT_REPORT

| Field(Art) | (Abbrev) | (Number) |      (Titel) |

------------------------------------------------------

| Directive |  LVD    | 2006/95/EC            | Low Voltage |

..(max 1-5)

| Regulation | (empty) | (EG) 1275/2008         | Ecodesign requirements |

. .(max 1-5)

| Standard   | (empty) | EN 60335-1:2012+A11:2014 | Household - Safety - Part 1: General requirements |

..(max 1-20)

Aim :

This table is for Word export and since all data need to be in one record it need to be converted to one row of fields only. New table DoC-EXPORT single row should look with fix field names like:

REG_01 | .. | REG_5 | DIR_01 | .. | DIR _05 | STD_01| .. | STD_10|

Not used fields stay empty. I tried a few things and googled but have no success. Can you give some tips ?

Thank you

Hans

 

Outcomes