Compare to whole column in excel sheet

Help
1

Flow.zip (12.5 KB)
Can anyone tell me where can I mistake it?

Thanks in Advance

2

Hello @Abubakkar,
Can you describe a little the actions which needs to be performed in on this excel sheet? I’m trying to understand your workflow decision conditions.

3

Thanks for your reply @Pablito

if Action is null then result column is Invalid
material id is null then result column is Invalid
Material Description id is null then result column is Invalid
UOM id is null then result column is Invalid
Purchasing Group id is null then result column is Invalid
Material Group id is null then result column is Invalid
Valuation class is null then result column is Invalid
Price control id is null then result column is Invalid
Price id is null then result column is Invalid
Industry Sector id is null then result column is Invalid
Material Type id is null then result column is Invalid
Plant Type id is null then result column is Invalid
Storage Location id is null then result column is Invalid

4

Just I want to validate entire excel sheet before entering SAP applicationMain (1).xaml (1.3 MB)

5

Based on the conditions (ex. row(0).ToString="" and row(1).ToString="") it seems that you are comparing whole rows. But based on what you wrote I think you need to compare only the particular cells in your rows.

1 Like
6

SAPAutomation2.xlsx (14.9 KB)

for your references

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?

Thanks

7

Excatly particular cell but if that cell value is null or wrong value or too length then It’s going to be a error. I should validate that particular column and I get the result in my excel sheet

8

I think this can be done only by using DataTables. You need to get particular range from excel, assign it to DataTable and using loops compare the data. I know that you need to validate column but still in your decision workflows there are comparison of whole excel rows. By this I meant that you are taking whole section from A1 to P1 (in your case) and comparing it to A2 to P2. This will not work this way. You need to take each particular cell and compare them like A1 compare to A2, B1 compare to B2 etc.

1 Like
9

Yeah I got it … but Can you show me in one cell column excel sheet tehn I’ll understand more clearly …
it’s very needful help for me…

10

For example if the column value is null I can use this condition to validate row(0).ToString="" and row(1).ToString=""
or String.IsNullOrEmpty(MATIDDEL) or String.IsNullOrEmpty(matdeschng)
if the column value is wrong credential what kind of condition should I use?

11

In this case you condition says:
If this

image
image1683×23 1.99 KB
is empty
and this
image
image1684×27 2.1 KB
is empty
set this
image
image1709×28 548 Bytes
“Invalid”.

It looks for me that are wrongly understand the rows.

1 Like
12

@Abubakkar here I’ve prepared for you an example how to handle with cells and compare values from columns. Hope this will help you.
cells.zip (7.9 KB)

13

I really appreciate your help @Pablito Thanks.
But I exactly need this solution :point_down:

Screenshot%20(16)
Screenshot%20(16)1366×768 68.5 KB

14

In that way you need to build kind of database with possible values and keep it in separate DataTable then inside a loop compare each cell with all values from this database and put result to let’s say ‘RESULTS’ column for particular row index.

EDIT: It’s only my thoughts but there can be many ways to solve it. You just need to think which one will be the easiest one. If I have problems like this I’m trying to write all thing on the paper and do some ‘sketch’ to figure out the scenario.

15

Hi @Pablito
Just I executed entire excel sheet before entering SAP application
this for your reference
Main (1).xaml (1.8 MB)
There is do you know any easy way to execute this process
please let me know

16

but the thing is it’s only validate for null value
if once come any other error value what kind of condition should I use ?

17

Main (1).xaml (1.8 MB)

Successfully completed this processSAPAutomation2.xlsx (14.9 KB)
Thanks @Pablito

2 Likes
18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.