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 have a Multiple join the result has replicated ID fields (fields that are used for the join) for each file. There are some nulls in each column due to missing values in that source (this is expected). I am currently using a IF THEN ELSEIF to combine into one column. I feel like there is a more efficient way to accomplish this, especially as the number of tables increases. Suggestions? Thanks for any advice.
In the Join tool, deselect one of the ID fields so it doesn't come through the "J" stream --- in this example, I deselect the right ID field. Then in the Union tool, select to "Manually Configure Fields" from the drop-down at the top and use the arrows to put your ID's in the same column: