i have situation like there is one CRM, where i need to search for initial. but there are some initials (i am passing scraped initial variable)
let say REHK
if i type “REHK” in search bar, it will display related result as well like “resp”, “rkmp”
but i want the details REHK only.
then, what details i want to check is DEptno and manager of REHK ,if the value matches then display “matched”.
yes, suppose i am searching for initials let say “REHK” so the result i should get is the all the details of REHK like name, age , department etc, but there are some initials if you search let say “AIDT” it will display you the result related to other person’s initials also like
AIDT
AMt
AMRT etc
but what i want is the result of “AIDT” only and then it should look for DEPtno and mngr of AIDT based on condition as i explained the condition earlier in forum.
what i have done
i passed the scraped variable in the search bar
then scraped the data using data scraping, store in a variable.
took for each roe loop to iterate(i think it will work in for those initials like AIDT ) where more than one initials are coming.
put condition if var sinitials= row(Initials).Tostring then
check for DEPTno and mngr, if matches then log msg.
ok, i also wanted to write that condition because some of the initials doesn’t have any value in CRM, how to write that condition, what place i should write the condition for that.so that if the value is not found it execute the next step.
i think there is some confusion, actually after searching the initial in CRM, it display whether the data is there or not,pls follow the img on the above comment.
And that i need to capture.
suggest me some idea pls
Usually this confusion started, as we are mixed up with many issues in one post, I suggest to close this post and start a new post with your specific problem
As you see that your problem to this post is data table filter, that was solved long back, I suggestes to mark as solution, But you are still continuing the same post with different issues
If you do all your logic one workflow that will be always confused, like wise multiple problem sets in one post will also confuse, and there will be no chance to others to contribute.
I suggest to close this post and start another post