I am trying to create the attached table that uses multiple data sources. I am having problems with the placement of the Data Source Configuration element and the queries. I can make a single column work but not multiples. Any help would be very much appreciated.
Dragos.Cojocari 270001QUCG1654 Posts
Re: A Table With Multiple Data Sources2013-11-26T16:47:03ZThis is the accepted answer. This is the accepted answer.
if you are trying to have 1 DS per column and have each entry on a separate row like I printed below then that's something you cannot do in RPE as in RPE you can only iterate vertically in a table on rows. Depending on the size of your data you could however make this "join" in memory in a variable and then iterate on that variable's contents.
| DS1 | DS2 | DS3
1 | rec 1 in DS1 | rec 1 in DS2 | rec 1 in DS3
2 | rec 2 in DS1 | rec 2 in DS2 | rec 2 in DS3