Need to create a new column with manual formula and reference to an external source file

Question

Hi there,

Need your expertise for the below points. Inlcuding the sample file for your reference.

1.  Need to create a new column with manual formula like concatenation and IF

2. And to create a new column with reference to an external file wiht the help of vlookup

Sample.xlsx

binu_acs · Answer

@itssreeji similar approach of @davidskaife , this can be done by using the Find and Replace tool

Location_10_07.yxmd

davidskaife · Answer

Hi @itssreeji

Here's my approach:

Create a Lookup table to map the location codes to the name of the location, and use the find/replace tool to apend the field on based on matching Location codes (i'd do it as a lookup table rather than a formula as that way you don't need to amend the formula when a new location is needed, you just add the location and the name to the Lookup table instead)

Concatenating the two fields together is then done in the formula tool.

I've attached the workflow for you to see.

RE: part three of your questions -  if i'm understanding it correctly you should be able to create the new column using the find/replace tool if you want to have a go at it!

itssreeji Workflow.yxmd