Hello everyone,
I am currently working on a process where I want to enter several orders automatically in SAP. I have the files as Excel files and I can also enter them automatically. I have solved this with If-Else conditions. But now it only works if all orders have two articles or one. But I wanted to implement it so that it also accepts orders with a different number of articles. But somehow I can’t get it to work with the If-Else conditions. I used Excel Row for the For Each activity.
I believe in if else you are checking 1 or 2…
Instead use a loop inside and loop for the number of times you need or for number of items
Then inside loop index property can be used to find the item number and change the cells or rows
Cheers
It looks like this…as per the code what you have shows should be working as ezpected
In the aecond if condition you dont need to write String.IsNullOrEmpty(CurrentRow.ByField(“Client”)) and it comes to else only when it is empty
And in the else condition of the else condition that is when both client and material are empty…a new one is starting so accordingly give the values in it else condition…
Already what you have done is almost proper
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.