If Is Null Logic

Good afternoon all,

I have what is hopefully a simple question. I have some logic that groups various forms of customer names by a uniform naming convention. It is based off the spread sheet attached. However, my logic leaves the customer name blank if its not listed in the attached spreadsheet instead of using the default destination name. Is there a way to fix that? Below is the logic I am using and the spreadsheet i am using. any help would be greatly appreciated.

If IsNull([Group_Name]) then [destination_name] else [Group_Name] endif

Grouping Logic (Dest Groups).xlsx

Workflow

Developer

Tips and Tricks

Accepted answers

jrgo

@czjames87

Issue why your expression isn't working is because the Data Cleanse tool you have ends up converting NULL fields to BLANK.

Instead of using IsNull, use IsEmpty. This qualifies both NULL's and BLANKS whereas IsNull only qualifies NULL.

If IsEmpty([Group_Name]) then [destination_name] else [Group_Name] endif

Edit:

Actually that may not be your issue since unmatched from your Find Replace tool would have produced a NULL value. Would likely need to see what the data coming from your LOAD (Dynamic Input) tool is producing and what you're expecting the results to look like vs. actual.

All comments

apathetichell

On your data upload - the field is called Group Name - not Group_Name so your if statement won't work.

If IsNull([Group Name]) then [Grouping Logic] else [Group Name] endif - works. This is set up to overwrite your group name field.

If this doesn't help could you upload a different data sample?

Qiu

@czjames87

Agree with @apathetichell Maybe you are trying to do something like fuzzy match?

It will be better you can provide a sample input and output for us to better understand your question.

czjames87

Below is the sample flow.

I don't think the logic is the problem. I think the problem I am having is the find replace tool farther down the flow.

LEX_Grouping_Flow (3).yxzp

czjames87

I changed the column name from Group name to group_name in the select tool up stream in the flow.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335