Hi,
I have a connection to postgresql server through ODBC that works ok. A table has become too large and now every time I need to update it, it takes too much time.
The only idea I came up with was to prior to retrieving of ALL the data from the table, write a query to filter it, so I get only the data I need.
Right now when I write my SQL code on the window shown below (sorry the language) and press accept, it throws Expression.Error: The key didn't match any rows.
Any idea of what should I do?
Thanks
Solved! Go to Solution.
I see now. Copy all the code from the custom step you added, from "let" to "in Source", then open up Advanced Editor. Delete everything and paste in your code there
Create a new blank query and use the below
let
Source = Odbc.Query("dsn=Reporting Server", "
select * from my_table where my_filter = 1
")
in
Source
You can add any steps needed afterwards to change data types etc
HI johnt75,
I didn't fully understand your reply. This is what I did.
And got this error
What am I doing wrong?
Thanks!
remove the ; at the end of your query, it should be fine then
Still got the problem.. 😞
I see now. Copy all the code from the custom step you added, from "let" to "in Source", then open up Advanced Editor. Delete everything and paste in your code there
Thank you, finally I just copied the SQL code (without the ; at the end, that's why it didn't work when I first tried) and it worked.