/profile-content.jspa?filterID=contentstatus[published]&targetUser=9758 Recent content in Tableau Community Forums en Sun, 17 Jun 2012 21:38:48 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2012-06-17T21:38:48Z en https://community.tableau.com/thread/118539 <!-- [DocumentBodyStart:37665cca-a707-4114-af19-187ddd371498] --><div class="jive-rendered-content"><p><a href="https://community.tableau.com/servlet/JiveServlet/showImage/2-180881-2479/lookupintootherrows.jpg"><img alt="lookupintootherrows.jpg" class="jive-image-thumbnail jive-image" height="180" onclick="" src="https://community.tableau.com/servlet/JiveServlet/downloadImage/2-180881-2479/450-180/lookupintootherrows.jpg" style="" width="450"/></a></p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>The first 4 columns are what I have now, would like to create a calculated field that, per row, finds matching artist by artistID and puts its country in the new column. Tried RAW commands and they didn't seem to be the right way to go about this.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>The use case might not quite make logical sense here as I've altered its nature to not violate company privacy. The actual nature of the data makes this make sense, so please ignore that minor fact <span aria-label="Happy" class="emoticon_happy emoticon-inline" style="height:16px;width:16px;"></span></p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks in advance!!</p></div><!-- [DocumentBodyEnd:37665cca-a707-4114-af19-187ddd371498] --> calculation lookup Sun, 17 Jun 2012 21:38:48 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/118539 2012-06-17T21:38:48Z 7 years 1 week ago 2 0