CODEWITHSUNDEEP
tableau-apitableau-desktop
dan
dan

Reputation: 493

Tableau: How do I copy row value for unique identifiers?

How do I add calculated field for this?

I have table in tableau in following format (connected through redshift and every day 100000 rows are appended for the same ID1 and ID2, and sometimes new values for ID1 and ID2 are also added):

![enter image description here

Value in Date Field 1 could either be Null or some date value (which is appended every day). What I want is whenever for specific combination of ID1 and ID2, Date Field 1 is not Null, I want that value to be copied to other rows also as follows:

enter image description here

How do I do it?

Note: I got an answer for this question under SQL tag but it is with UPDATE table method: SQL: Copy values for unique keys from one row to other

But I specifically need answer for tableau also to add calculated field.

Upvotes: 0

Views: 167

Answers (1)

Fosstin
Fosstin

Reputation: 141

You can create a calculated field using IF THEN statement as in the images below to look for a Match:

enter image description here

You can see the data reflects the new Match field as well:

enter image description here

Upvotes: 0

Related Questions