This isn't picking up ValueR for me. My actual column names are different then what I posted but the output is as follows with ValueR being the one showing Null. I think the problem has to do with how Tableau treats empty I think? If you look at the original 2 screenshots I posted I don't see the word 'NULL'. Is there a difference in Tableau with empty data vs NULL?
The translation between the sample I posted and below is
ValueR is the NLL,
ValueM is Mail
iValueP is Mail Order
So its Finding
R + M
But not find R + empty
I am super confused on this pl attach some workbook
I apologize if I'm not making this clear up. Unfortunately I cant post a workbook due to sensitive nature of data and size however the difference between the workbook you posted and the one I am using is that in your workbook for Column1 when there is no letter it shows Null. In my workbook which is pulling from a database Tableau datasource tab doesn't put Null in there, its just empty if there is no letter. So perhaps the problem is with using ISNULL function. Is there another way to test for empty cells in Tableau. So it doesn't seem to be finding ValueR which has R for column2 and nothing for column1
Your Column1 My column1
If you want to create nulls then create a new column with this:
this would convert blank to null and if you want to fill zeros for these generated nulls
So the new calculation would be:
IF (Column2="M" AND ISNULL([Column1])) THEN " ValueM"
(Column2="R" AND ISNULL(Lookup(min(Column1),0)) THEN "ValueR"
(Column2="R"AND [Column1]="M") THEN "ValueP"
No first create a new column like this:
That wont work. The original column is a string.The values in column1 are letters. It gives the following error.
ifnull is being called with (string,integer), did you mean (string,string)
Just put “B” in place of last 0
Doesn't work. Gives error saying "Reference to undefined field B"
ifnull(lookup(min([Maint Choice Cd]),0),B)
Put “B” not B