In this i want search for the job id and should get the report name to the id how can i get that @Palaniyappan
Fine
Hope these steps would help you resolve this
—use excel application scope activity and pass the file path as input
—inside the scope use a read range activity and get the output with a variable of type datatable named dt
— use a assign activity like this
str_input =“Yourvalue”
—now use a Lookup datatable activity
In that mention these stuffs in the property panel
—input
Datatable - dt
Input value - str_input
Lookup column index 0
Output cell value -str_output
Target column index 1
Where str_output is a string variable which will give us the name for the report if
Cheers @Karthikeyan34