Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
3 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
VIP

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
3 years ago

Hi Marc,

What did you use to join the two tables?

Thanks,

  • ckattookaran's avatar
    ckattookaran
    VIP
    3 years ago

    You can use LINQ to join two datatables.

    • MarcR's avatar
      MarcR
      VIP
      3 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?

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

        Hi Celvin,

        I have never used LINQ. Can you please provide an example of how it would work?

        Thanks,