AnsweredAssumed Answered

Comparing filter value with value reading from excel sheet and update the sheet

Question asked by girijak on Feb 1, 2018
Latest reply on Feb 2, 2018 by gadpr08

Hi Team,

 

I have a scenario where am filtering one element suppose say CustomerId from request xml. I have the customer details in excel sheet.

so my scenario is i wanted to check whether the customerId coming in request exist in excel or not,if exists nothing needs to be changed, it will go to image selection step. If the Id doesnt exist then i have to update the excel sheet with the Id coming in request and route to image selection step.

 

I used Parse text from XML filter for filtering the ID value from request XML and i used read rows from excel sheet dataset inorder to read data from excel sheet.

 

I tried to compare using ensure the properties are equal assertion and write to delimited file utility.

if the assertion boolean value is false then go to write to delimited file step.But it didnt work for me.

 

Could you please help me in solving this scenario.

 

Thanks in advance.

Regards,

Girija.

Outcomes