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 building up a data set from multiple resources, I have a matching ID column in both data sets to join the tow separate entries into one wide data set by using the join tool by ID column and get to keep some of the new columns into the blended on data set using join tool. However , Join will only keep the matching ID data and eliminate the non matching IDs into L or R entry!
My goal is to add the new column from the second data set by matching it to its corresponding ID from the first data set while assigning zero values or nulls to the introduced column from data set 2 for the rows that does not find a matching ID
I tried Union tool but it does not work because When I try to union L & J from the outputs of Joint tool, it only stack up ID column, while I want stack the new introduced column which is not existing in the first data set
Can anyone give me a quick help with that? I need to solve this issue to proceed with my research project and I am stuck !
It does sound like you need to use the Union tool but perhaps you need help with it?
Here is a workflow that shows how you union the data from the second dataset with the 1st. When you union in data from the 2nd dataset with the joined data, it will show null values in the fields that don't exist in the 2nd dataset. If you need more help with it, put some sample data together and I'll demonstrate with your data.