How load List of values from Excel file (including Label) ?
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”
il y a une limitation dans excel. comment contourner cela? 8192 caractères maximum dans une formule.