Aller au contenu principal

Table.AddIndexColumn

Ajoute une colonne avec des valeurs de position explicites.

Syntax

Table.AddIndexColumn(
table as table,
newColumnName as text,
optional initialValue as number,
optional increment as number,
optional columnType as type
) as table

Remarks

Ajoute une colonne nommée newColumnName à table avec des valeurs de position explicites. Valeur facultative, initialValue, valeur d'index initiale. La valeur facultative, increment, spécifie l'incrément de chaque valeur d'index.

Examples

Example #1

Ajoute une colonne d'index nommée " Index " à la table.

Table.AddIndexColumn(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
}),
"Index"
)

Result:

Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567", Index = 0],
[CustomerID = 2, Name = "Jim", Phone = "987-6543", Index = 1],
[CustomerID = 3, Name = "Paul", Phone = "543-7890", Index = 2],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550", Index = 3]
})

Example #2

Ajoute une colonne d'index nommée " Index " à la table, en commençant à la valeur 10 et en incrémentant par 5.

Table.AddIndexColumn(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
}),
"Index",
10,
5
)

Result:

Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567", Index = 10],
[CustomerID = 2, Name = "Jim", Phone = "987-6543", Index = 15],
[CustomerID = 3, Name = "Paul", Phone = "543-7890", Index = 20],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550", Index = 25]
})

Category

Table.Transformation