I saw a filter area in Visual Preview and wanted to inspect my data to make sure I got the same number of rows as my source data has which was 92,688. I did not. I'm not sure why. I filtered on the column that has 92,688 entries, but what was returned was 93,231 (543 empty rows/records). I have no empty rows in any of my source data either. I'm using FeatureJoiner to bring over a column that was not in my original data. The two source files have a common attribute: LocationID. The Source file has 4,500,626 rows, and my joining source file has 92,688. When I joined the data it came back with the 4,500,626 rows with my added column and data (92,688). So why does my filter show 543 blank rows more?
Question
Visual Preview has filter but gives me more rows/records than what I'm filtering on. Why?
+13- Safer
@Bonnie Nohalty If you use a Tester to test for features where DPI500ft = DPI, do you get the same number of rows as shown in the Visual Preview or does it show 92,688?
@Bonnie Nohalty If you use a Tester to test for features where DPI500ft = DPI, do you get the same number of rows as shown in the Visual Preview or does it show 92,688?
To answer your question, while I was waiting for assistance, I flipped this FeatureJoiner module to read in my Left file as my main Addresses file, and join in Right the smaller address file based on the common attribute. I didn't have the problem after that. No I didn't put a tester on it originally, so I don't know what that would have showed me. I started to wonder if rows were being appended or if its because I had my Left & Right inputs backwards it did something. I'm not sure. Thank you for reminding me to use a tester when things happen though. Can I ask another question though? There was a little circle (not transformer) but it gets connected between the transformers and it does something. I can't find it and don't remember why I used to use those in the past. Do you know how I find that little guy again and what it does?
+59- Evangelist
To answer your question, while I was waiting for assistance, I flipped this FeatureJoiner module to read in my Left file as my main Addresses file, and join in Right the smaller address file based on the common attribute. I didn't have the problem after that. No I didn't put a tester on it originally, so I don't know what that would have showed me. I started to wonder if rows were being appended or if its because I had my Left & Right inputs backwards it did something. I'm not sure. Thank you for reminding me to use a tester when things happen though. Can I ask another question though? There was a little circle (not transformer) but it gets connected between the transformers and it does something. I can't find it and don't remember why I used to use those in the past. Do you know how I find that little guy again and what it does?
You're probably thinking of a Junction.
To answer your question, while I was waiting for assistance, I flipped this FeatureJoiner module to read in my Left file as my main Addresses file, and join in Right the smaller address file based on the common attribute. I didn't have the problem after that. No I didn't put a tester on it originally, so I don't know what that would have showed me. I started to wonder if rows were being appended or if its because I had my Left & Right inputs backwards it did something. I'm not sure. Thank you for reminding me to use a tester when things happen though. Can I ask another question though? There was a little circle (not transformer) but it gets connected between the transformers and it does something. I can't find it and don't remember why I used to use those in the past. Do you know how I find that little guy again and what it does?
That's it! thank you...