Return designated name if value not present

[Lance1]

I have a list of properties that I am linking to and joining to another table in my app on "Property Name".

The list in LSP Chain Properties only contains properties that ARE LSP properties, whereas Customer Account contains hundreds of thousands of properties that are not LSP properties.

Since the properties aren't on the list for "LSP Property" in my if statement, there are not any properties showing in my app as "Non LSP" though the code works fine to rename the property type as "LSP" when they are on the list.

Any help on how to accomplish returning "Non LSP" for properties not on the list would be appreciated.

I have attached the code if that is helpful.

[vinieme12 · Accepted solution]

Use ApplyMap() instead of Join

Map_lsp:

Mapping Load

PropertyName,if(lsp='Yes','LSP','Non-LSP') as Lspflag

From XYZ;

CustomerAccount:

Load * , Applymap('Map_lsp',[Seller Customer Account],'Non-LSP') as [LSP Property]

From XXXX;