How to get the reference data from an excel sheet?

Help
,
1

I want to get the capital city (Column2) as an output by using the country name (Column1) from an excel file.

countryies

You type the country as an input and the workflow outputs the capital city.

Austrlia

Output is a capital city
Capital%20city

2

get your data into a data row and using for each row activity you can check the country using assign activity and get the city from that data row

1 Like
3

Thank you so much @Vidwa
It is now working

Capital_city.zip (21.4 KB)

4

Main.xaml (9.6 KB)

3 Likes
5

You can try with this Capital_City.zip (21.4 KB)

1 Like
6

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