locked
0 in a window group for not presented car maker RRS feed

Answers

  • Hi,

    You cannot do that with the current sample you're looking at. One way to do that will be to build a list of all the car makers and store it in a SQL Server table, configure the job in the sample to write the results to the same SQL Server database and do a right join with the results of the query in the sample to achieve that.

    Hope that helps.


    This posting is provided "AS IS" with no warranties, and confers no rights

    • Marked as answer by Zafar Abbas Thursday, October 1, 2015 4:18 PM
    Thursday, September 24, 2015 6:49 PM

All replies

  • Hi,

    You cannot do that with the current sample you're looking at. One way to do that will be to build a list of all the car makers and store it in a SQL Server table, configure the job in the sample to write the results to the same SQL Server database and do a right join with the results of the query in the sample to achieve that.

    Hope that helps.


    This posting is provided "AS IS" with no warranties, and confers no rights

    • Marked as answer by Zafar Abbas Thursday, October 1, 2015 4:18 PM
    Thursday, September 24, 2015 6:49 PM
  • Proposed approach does not work, because only left join is allowed in Stream analytics language and reference data may be on right side of this query only. May be another metadata events can help.
    Friday, October 2, 2015 10:29 PM
  • @YevgeniyP, did you ever find a solution for this problem? I've been working on a couple different attempts but without success so far.
    Saturday, March 11, 2017 9:25 PM