I have two different excel sheet, Invoice excel and Unique excel. Invoice excel with SAP invoices list and Unique excel with unique date that existing in invoice excel.
Lets say if the unique excel sheet have three different dates, August 3,4 and 5. I have to read the first unique date means August 3 and do the filter in Invoice excel sheet.
Yes I have same snario like yours SAPAutomation2.xlsx (11.0 KB)
Iβm going to compare entire excel sheet (Validate) that column value is right or wrong?
what kind of conditions should I use? could you suggest me please?
@Abubakkar if you want to validate values of all columns. Then read the excel using for each datarow you have to check the conditions for all columns. Can you please elaborate your question more?
Thanks for your help @Manjuts90
I need a solution for the following condition:
Action is null and material id is null then result is Invalid
Action is value and material id is null then result is Material id is invalid
Action is null and material id is value then result is action id is invalid
Action is value and material id is value then result is action id is created
Yeah Itβs executed perfectly thanks @Manjuts90 then Incase
if I need to validate till last row of excel sheet
Can I use this Condition?
row(2).ToString=ββ and row(3).ToString=ββ
row(4).ToString=ββ and row(5).ToString=ββ
row(6).ToString=ββ and row(7).ToString=ββ
row(8).ToString=ββ and row(9).ToString=ββ
row(10).ToString=ββ and row(11).ToString=ββ
row(12).ToString=ββ and row(13).ToString=ββ
Hi,
If column value is βSathees Kumarβ or β12345678910β in excel sheet
but currect value is βSatheesβ and β123β
now iβm going to validate this column in excel sheet
I should indicate in excel sheet result column βsathees Kumarβ is too length so it is invalid or β123456789β is too length so it is invalid
how can I omit other elements or texts?
Can you help me to solve this solution?
@Abubakkar In this workflow we are checking only whether column values is null or not only. Regarding your question from which column your getting those u have to mention that column index with required condition. whether value should be of certain length give that length in condition.