[Stackoverflow] [Progress OpenEdge ABL] power query - How to limit rows extracted from a Progress Database

Status
Not open for further replies.
J

Jacques

Guest
I am connected to a Progress OpenHedge Dadabase though ODBC. I want to limit the number of records extracted but I cannot figure where to put the sql code. sample code reads as follows:

Code:
Source = Odbc.DataSource("dsn=ODBCMXP", [HierarchicalNavigation=true]),
abcd_Database = Source{[Name="abcd",Kind="Database"]}[Data],
PUB_Schema = abcd_Database{[Name="PUB",Kind="Schema"]}[Data],
#"invoice-line_Table" = PUB_Schema{[Name="invoice-line",Kind="Table"]}[Data],

I would like to limit records to Documentnumber > 10000 for example or DocumentDate > "2022-01-01" for example.. the same problems arise on other tables where millions of rows are read and need to be filtered out after and thus increasing update time. Help with the query code would be appraciated !

Continue reading...
 
Status
Not open for further replies.
Top