This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am attempting to join four excel files together using the multiple join tool and asset number as the specific join field. There are a total of 67,198 records but I am not sure why the first 25,000 contain null values and there are null values in between as well. All four asset numbers from each file have a data type of double. I was assuming that it would output the asset numbers without any null rows. Am I doing something incorrect. Any help would be much appreciated.
Excel likes to consider null rows/records as valid inputs. Put a browse after each of the Input tools and scroll to the bottom to see if they are there. They appear first in your join result because the join field is sorted when joined so the null values will be sorted to appear first.
To resolve this, put a Filter tool after each Input to remove the records will null Asset Numbers using the following formula:
The excel files have no null values for asset number but I was unaware that the multiple join tool shows nulls for records that don't match. I guess I am stuck using the union tool, but the problem is that there will be 105,658 asset numbers. Maybe I could use join tools and split the input data files up and then connect the streams to the other input data files.
I'm having a similar problem. I have a join multiple with 6 inputs. None of these six inputs have null values in them. They all have 45 actual valid values. Coming out of the join multiple I have 46 records. One of these has null in every field. The only thing I can do is use a filter AFTER the join multiple to filter out the random null record.