Power Query Duplicate Initializer

[cr731]

In Power Query, is there any way to lead multiple statements with the same variable name?

Here is an example,

let
   MyTable = Access.Database(...)
   MyTable = Table.SelectRows(MyTable, each [ColumnToFilter] = "FilterValue")

in

   MyTable

Basically, I want to import a table and make changes to it, without having to create a new "MyTable" string at the start of every line.

But if I try the above code, I get a "Duplicate Initializer" error.

Just wondering if there is a better way to write M code in a situation like this.

 

[anvg]

Hi
You cannot use definition of MyTable variable twice. The Power Query language is not VBA
Please, use

let
   MyTable = Access.Database(...)
   neededRows = Table.SelectRows(MyTable, each [ColumnToFilter] = "FilterValue")
in
   neededRows

instead
Regards,