How can i assign columns to the index created while creation through Excel import?

[srujan_gannamaneni]

Hi All

I am new to Power Designer.

I am trying to create the PDM through Excel Import where i want to mention all the values which are needed for my Table.

I tried assigning the columns to the index in the excel sheet but i couldn't map while assignment.

Kindly help.

Please give me an example how to set the excel sheet for Index columns if possible

Best Regards

Srujan

[GeorgeMcGeachie]

Here's how you add attributes to an identifier in the LDM using the Excel import:

• Call the Excel sheet 'Entity.Identifier.Attributes'
• Have the following columns in the sheet
  • Parent - the name of the Entity
  • Name - the name of the identifier
  • Attributes - a list of attributes in the identifier
    • qualified by entity name - e.g. "Customer Account"."Customer Full Name"
    • if you have more than one, use the separator defined in the Options tab in the Excel Import Wizard (usually a comma)

It should work in the same way for a PDM, just change the sheet name to 'Table.Key.Columns'.

[srujan_gannamaneni]

Hi George

Thank you, I have tried the solution which you have suggested. But I couldn't assign the columns.

I have made a sheet named Table.Index Index.Column and gave details as below

Table, Index Name, Index.Column

It has thrown a error that column could n't be assigned as the object is read only.

Is there a way we could convert an object read-write?

Regards

Srujan Gannamaneni