I remember seeing just yesterday somewhere in the help files about multiple row types for something in a BPM query. I can’t remember where to find it now. I am trying to do a query that ties my ttECORev table to ECOMtl and am getting double rows. I am only getting one row from the ttECORev table (when I do a table query, but 2 when I do a field query???) , but I get two identical rows when I run the fill table by query that ties those two together and maps all of ECOMtl to a Data Set. How to I differentiate that second row to only return one?
I figured it out. I had to put not equal to “”. I was trying to use IsNull to filter out the existing rows.