Уважаемые Форумчани, добрый вечер!
Просьба, создайте Excel-файл, для 3-х примеров ниже. Просто,на словах никак не понимаю их.
Заранее благодарю!
1:
Код |
---|
Table.RemoveRows(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"]}), 1, 2) |
2:
Код |
---|
Table.RemoveRows(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"]}), 1) |
3:
Код |
---|
Table.RemoveRows(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"]}), 0) |