How i can check that excel data is same as queue data how can i compaire excel data with queue data

Help Studio
, ,
1

How i can check that excel data is same as queue data how can i compaire excel data with queue data

2

Try the below sequence. but if you need particular scenario, let us know

image
image775×844 27 KB

3

yes actually i have check that my excel having name column and queue have data like first name and last name in my code i fetch strName=FirstName+LName from queue
Now i have clolumn in excel with Name gajare,sandhya
so my queue name come as sandhya gajare and excel name gajare,sandhya
so i have to do string operation and match both value how i can do

please help me out

4

Use.ToUpper For both excel and queue data
if you are 100% sure excel data will come with “,” replace “,” with space " "
and also use Contains rather than “=”.
can you provide your workflow if possible? it’s easier for us to look.

Cheers
Thanks

5

image
This is my excel
Process.xaml (36.6 KB)
This is code

image
This is code where i fetch queue data
image
this is condition i am checking
plz provide me code

6

@whitestar can you help me

7

Name compare.xaml (10.0 KB)

please see the workflow. you can combine the activity with one sentence I separated for you to understand.

8

hi how can i write the queue data to existing excel