The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
4 years ago

Join Framework table data to Application table data using SQL

SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user...
Data Integration
MarcR's avatar
MarcR
Contributor II
4 years ago

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

  • Tom_R's avatar
    Tom_R
    New Contributor III
    4 years ago

    Hi Marc,

    What did you use to join the two tables?

    Thanks,

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      You can use LINQ to join two datatables.

      • MarcR's avatar
        MarcR
        Contributor II
        4 years ago

        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?