Forum Discussion
Solved
Parameter changing datasource type DB2->ODBC
Hi, I have this M code and trying to return the TABLE1 table for conditionally 2 datasources (ODBC and DB2) which has the same structure. I'm not good at M: I think that the third row generates ...
Hi AGo,
in M, every query step can be seen as a variable. So your requirement can be solved like this:
let Odbc = Odbc.DataSource("dsn=dsnname", [HierarchicalNavigation=true]), DB2 = DB2.Database("servername", "test", [Implementation="IBM"]), Origine = if para = "ODBC" then Odbc else DB2 in Origine
Invoking ImkeF
Hi AGo,
in M, every query step can be seen as a variable. So your requirement can be solved like this:
let Odbc = Odbc.DataSource("dsn=dsnname", [HierarchicalNavigation=true]), DB2 = DB2.Database("servername", "test", [Implementation="IBM"]), Origine = if para = "ODBC" then Odbc else DB2 in OrigineWorks like a charm! And thanks forthe functioning explaining.
