How to use mapping

Help
1

how do I fetch only rank of UT, state and HDI of 2018. pls share a file

c2
c2937×546 100 KB

2

link

3

Just scrape the entire data to a data table @KarthikBallary, I hope you already did that.

Then you can simply filter the entire data table to the required using filter data table activity

4

By the way, the data column names are not clear in the data table. so try writing the entire extracted data to an excel and then read the same excel and then filter it @KarthikBallary

5

new Dictionary(of String,String) from{{“key1”,“string1”},{“key2”,“String2”}}
this is for string, string
how do we write for Int, String

6

1111

I am getting this exception

7

You need to declare a dictionary variable of type int, string

8

Why you are using for each?

If you have that variable as generic type, you need to change to char as per the screenshot

9

ok that issue is resolved.
I have done data scraping , It contains 22 rows
if I use for each it is going upto 7 row

10

Do the first issue is resolved? I mean the dictionary value @KarthikBallary

11

yes!

12

What is the issue you have now?

@KarthikBallary

13

table has 22 rows but only reading upto 7th row

14

Steps:
Extract table using data scraping and save it as one variable say dt_***
For each row in dt***
{
if row(“Rank”).tostring.contains(“UT”)
then
assign row(“State”) = variable str_state
assign row(“HDI 2018”) = variable str_HDI2018
Use Excel application scope /write cell or Write range to populate it in excel.
}

15

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