Monday, March 23, 2015

#384 Stream Explorer - References

Let's go back to our order exploration app -

Remember, this is what our input file looked like.

Now, as chance would have it, I have a DB table which contains the inventory status of
our products. We can add data from this table to our exploration as a reference.

To begin with, we need to add a data source definition to OEP -

Now I go to Stream Explorer and create the Reference -

Now we can add this to the Exploration

Just click on the Sources panel -

We now need to add a correlation between the two sources -

Join on Product -

I delete the summary, group by and filter -

Product is listed twice, but we can solve this easily -

Note the colour coding above.

No comments: