I have been using the tables in odata and would like to try to join some of them. Can these tables be joined, and if so can you provide how?
Best Answer
B
Bryan Baca
said
about 7 years ago
"my question is if I wanted to join Schedules and Bursts what column(s) would I use?"
You shouldn't need to. You will find a feed call BurstSchedules. If you load the feed in Excel, then you will find a Bursts hierarchy that you can expand to show Bursts in each schedule.
"if I wanted to Merge Documents and Bursts, what column(s)?"
Same for documents in bursts. Load the Burst feed then load the Documents hierarchy.
Hey Mike. Joining tables will be a function of whatever OData tool you are using. I am using Excel 2016 which includes a "Query Merge" feature to join together two table within the same workbook. I've attached a video showing the process. Let me know if you have any questions.
Hi Bryan, thanks for the information. However, it is not really the process that I am asking about but how to actually join the tables. In your example you show that you need to pick a column to join the tables on. To be specific, my question is if I wanted to join Schedules and Bursts what column(s) would I use? Also, if I wanted to Merge Documents and Bursts, what column(s)? I don't see any obvious choices.
Thanks
Bryan Baca
said
about 7 years ago
Answer
"my question is if I wanted to join Schedules and Bursts what column(s) would I use?"
You shouldn't need to. You will find a feed call BurstSchedules. If you load the feed in Excel, then you will find a Bursts hierarchy that you can expand to show Bursts in each schedule.
"if I wanted to Merge Documents and Bursts, what column(s)?"
Same for documents in bursts. Load the Burst feed then load the Documents hierarchy.
M
Mike Ciance
said
about 7 years ago
Ok. Got it. It was taking a long time for burstschedules to load so I gave up. I needed more patience! I also wasn't aware of the expand function.
Thanks!
Bryan Baca
said
almost 7 years ago
Microsoft's Power BI is a nice way to visualize this data and makes it much easier to join tables resulting from OData feeds. It's a free tool.
Mike Ciance
I have been using the tables in odata and would like to try to join some of them. Can these tables be joined, and if so can you provide how?
"my question is if I wanted to join Schedules and Bursts what column(s) would I use?"
You shouldn't need to. You will find a feed call BurstSchedules. If you load the feed in Excel, then you will find a Bursts hierarchy that you can expand to show Bursts in each schedule.
"if I wanted to Merge Documents and Bursts, what column(s)?"
Same for documents in bursts. Load the Burst feed then load the Documents hierarchy.
- Oldest First
- Popular
- Newest First
Sorted by PopularBryan Baca
Hey Mike. Joining tables will be a function of whatever OData tool you are using. I am using Excel 2016 which includes a "Query Merge" feature to join together two table within the same workbook. I've attached a video showing the process. Let me know if you have any questions.
Mike Ciance
Hi Bryan, thanks for the information. However, it is not really the process that I am asking about but how to actually join the tables. In your example you show that you need to pick a column to join the tables on. To be specific, my question is if I wanted to join Schedules and Bursts what column(s) would I use? Also, if I wanted to Merge Documents and Bursts, what column(s)? I don't see any obvious choices.
Thanks
Bryan Baca
"my question is if I wanted to join Schedules and Bursts what column(s) would I use?"
You shouldn't need to. You will find a feed call BurstSchedules. If you load the feed in Excel, then you will find a Bursts hierarchy that you can expand to show Bursts in each schedule.
"if I wanted to Merge Documents and Bursts, what column(s)?"
Same for documents in bursts. Load the Burst feed then load the Documents hierarchy.
Mike Ciance
Ok. Got it. It was taking a long time for burstschedules to load so I gave up. I needed more patience! I also wasn't aware of the expand function.
Thanks!
Bryan Baca
Microsoft's Power BI is a nice way to visualize this data and makes it much easier to join tables resulting from OData feeds. It's a free tool.
https://powerbi.microsoft.com/en-us/
-
How do I achieve load balancing using BI 4.x WACS?
-
What is the best way to suppress delivery of empty reports?
-
Event Based Schedule Running Past Midnight
-
Best practice to create a burst with production and development version of documents
-
attach an exisiting PDF document to Burst report
-
Delivery to a Cloud Drive
-
Standard Query
-
How to create delivery conditions for specific values?
-
How to apply Delivery condition while using Infoburst Content Grouping By Burst?
-
Parameters for IBShell Scripts
See all 26 topics