Hi Tom,
I tried this last month but OneStream confirmed that this is not possible in the current Azure Cloud. I first run the query on the framework to a datatable and then join that one with the application table. It’s a 2 step approach but works fine.
Marc
Hi Marc,
What did you use to join the two tables?
Thanks,
You can use LINQ to join two datatables.
Hi Tom, I actually have a really small dataset from the application (i select the scheduled tasks from the task scheduler) and then loop over these results in a Datatable. For every line (i have only 😎 i run a query on the Framework with the item from the application and append that to a DataTable.
However, i cannot imagine that there is no way to join two datatables.
Curious what LINQ means that Celvin states. @Celvin, do you have some more information?
Hi Celvin,
I have never used LINQ. Can you please provide an example of how it would work?
Thanks,
