Forum Discussion
Solved
Order attributes
Hello, I have the following table "PnL Structure" (not sure if I can consider it as a pure table since doe not appear in the Table view) and I need to give and order to each attribute, in order t...
DATATABLE returns a table and not a column. You need to modify the table itself and not create a calculated column. Note: The code i gave you was just a sample which of course didn't include all attribute values.
Hi Msampedro
What do you mean by "not sure if I can consider it as a pure table since doe not appear in the Table view"? DATATABLE generates a calculated table and should appear in the Table/Data view. You can actually add an extra column using the same calc table.
Example:
DATATABLE (
"Attribute", STRING,
"Sort", INTEGER,
{
{ "Qty (Liter)", 1 },
{ "Qty ((KG+EA)", 2 }
}
)
But I would very much create this table in Excel, and import it into the model using Enter Data.
