I want to convert US States Full Names into Abbreviations

Help Studio
, ,
#1

Hi Community,

I want to convert the fill name of the US states into Abbreviations (For instance, Maryland to MD and so forth). In the ‘state’ column, I want to see the abbreviations. Here is my sample input file. Can anyone help? Thanks!
InputFile_States.xlsx (9.7 KB)

#2

One of many options:

Create a lookup dictionary eg. by JSON input:

if needed Swap name and state code

then use a or each row and change the statename to the state code

#3

Hello @Sisay_Dinku

You can keep in an excel file or a json file and convert that to a dictionary.

Then use the country name as the key to get the abbreviation.

Thanks

#4

@Rahul_Unnikrishnan

Could you put that in the flow? I could quite get it.

#5

Can anyone help with this?

#6

@Sisay_Dinku
New Microsoft Excel Worksheet.xlsx (11.5 KB)
This is the excel sheet with states and its abbreviation
here is the workflow
Workflow.xaml (7.8 KB)

#7

@sangeethaneelavannan1 Thank you for the dictionary. I want to make it clear that I want the abbreviations are expected to be written sate names in the State Sheet from the States_abbr sheet after the vlookup. I am attaching the example.
Sates_VlookUp.xlsx (17.0 KB)
Thanks

#8

@sangeethaneelavannan1 I use modern design

#9

@Sisay_Dinku Workflow.xaml (10.6 KB)

#10

@sangeethaneelavannan1 That was excellent. It has worked. I’ll mark this as a solution. Thanks

#11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.