How load List of values from Excel file (including Label) ?

[Former Member]

Following Data Modeling Made Simple CHAPTER 21: How do we get information in PowerDesigner?  Page 461

There are two ways of importing List of values:

1. Pasting values and labels from the Windows clipboard ;

2. Importing values (but not labels) via the Excel Import wizard – all the values have to be in a single cell.

In fact you can import labels also.

Example : Domain 'Color' with this List of values :

Parent     Name          List of values

Color     Color Code     01     Red

                                  02     Black

In the Excel file under the column "List of values" insert this string of characters into the cell.

="01"&CAR(9)&"Red"&CAR(10)&"02"&CAR(9)&"Black"

CHAR(10) => (<Alt+Enter>) => New line => '\n'

CHAR(9) => Horizontal tab => '\t'

Good Upload!

Note: If you use Excel in English modify CAR for CHAR :

="01"&CHAR(9)&"Red"&CHAR(10)&"02"&CHAR(9)&"Black"