VLookup Function

Hi guys,

quick question on you. Here below I have data set where SA 2018 are account numbers and I would like to replace column "Description" with relevant Account names based on Account number. For this I also have another file (screen 2)

Screen 2

So I would like to make a code that would replace "1" in Description column with "Individual tangible fixed...". Then replace "2" with ... another English name from the list.

Any help is appreciated.

Thank you

Workflow

Datasets

Input

Common Use Cases

Accepted answers

RolandSchubert

Hi @MiroPwC ,

I think, you could join the tables based on SA 2018 and Account and use a formula to fill the description field. I've attached a sample workflow. Hope this is helpful.

Best,

Roland

ReplaceDescription.yxmd

All comments

RolandSchubert

Hi @MiroPwC ,

I think, you could join the tables based on SA 2018 and Account and use a formula to fill the description field. I've attached a sample workflow. Hope this is helpful.

Best,

Roland

ReplaceDescription.yxmd

estherb47

Hi @MiroPwC

You can join both tables on the SA 2018 and Account fields. Uncheck "Account" from the Right side, and uncheck "Description" from the left side (in the select tool part of the Join tool). You can then more the account name into position with the arrows, also in the Select tool part of Join.

Let me know if that helps.

Cheers!

Esther

fmvizcaino

Hi @MiroPwC ,

Attached is an example showing how to do it.

Take a look and let me know if this works for you.

BEst,

Fernando Vizcaino

2020-02-18 VLookup Function.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703