i am stuck in small logic, kindly help me to resolve my issue.
there is one CRM search option, in which if i search for some initial, let say ABC, it provide the details of ABC as a table.
so in some initials what happening is ABC is a scrapped variable which is passing everytime to the CRM search option, and it match with CRM data, but in CRM , column “initials” can be in upper case or can be in lower case as well like Abc or abC.
because of this for some of the data doesn’t match.
what i have done is
i scraped the data,
then put filter wizard, so that it should match the initials first and then look for other condition.
“Initials” is the column of CRM.
sNNinitials is scrapped variable.
so i want to convert the column value to be in uppercase always, so that it should match.
Just tested on my computer. The Filter Data Table activity doesn’t seem to care about the CaseSensitive option. So you will have to use DataTable.Select() to filter instead.
the situation is like i have some condition, which i have mentioned in filterDT, but the problem is, it is matching for some initials and for some it is not matching even the data is correct in Data table.
In today’s post you referred to “initials” but in the screenshot provided there’s nothing about “initials”. I can see that you are referring to “Dept. No.” and “Manager”. Can’t you apply the same logic as you did yesterday with @jeevith’s solution, but add Trim? E.g.
Hi! Move out the Filter Data Table activity and the Output Data Table activity outside the For Each Row loop. And also you need three assign in the the for loop:
Because you have the Filter activity in the For Each Row loop. You need to convert all the column values to upper case and trim first before the Filter activity. If you do the filter in the loop, some of the values might not have been converted yet and thus doesn’t match.