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?
+12- 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?
danminneyatsaf wrote:
@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?
+56- Evangelist
bknohalty wrote:
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.
bknohalty wrote:
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...
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.