This content has been marked as final. Show 1 reply
1 of 1 people found this helpful
Hey Rafael -
People normally approach this challenge in one of two ways:
- Reduce your data sources down from one to four by using the UNION statement to essentially "stack" each one of the tables on top of the other. If you search the forums for "UNION" you'll see lots of examples. This takes a little bit more work up front, but makes authoring MUCH easier.
- Add a table to the primary data source which includes ALL dates from each of the four tables. Then, use this new table to BLEND the four data sources together.