title: data merging in Tableau
body: <p>I have two sheets in excel. One has CBG (neighborhood) IDs as shown below.</p>
  
  <p><a href="https://i.stack.imgur.com/RfVAw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RfVAw.png" alt="CBG IDs"></a></p>
  
  <p>The second sheet has state and county names and IDs as shown below.</p>
  
  <p><a href="https://i.stack.imgur.com/sPrrw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sPrrw.png" alt="state and county data"></a></p>
  
  <p>Now the first 5 digits in the CBG ID are just the corresponding state and county IDs for that CBG.</p>
  
  <p>I need to to join this data together in Tableau so that I would have the state and county on the CBG sheet for each CBG.</p>
  
  <p>Basically I tried to blend the data and it didn't work. I also tried to perform a join calculation using the 5-digit code in the second sheet and the LEFT function to extract the 5-digits in the CBG code but it didn't seem to work either.</p>