Condition on excel sheet

Help Community
,
4

Like did u mean u need to enter all the order 1 details once while order2 for once like that?

5

yes , as i have to put them into a form and save it order by order

6

Hi @rpa13
Check this workflow
Main.xaml (13.9 KB)

I had added the comments so that it can help in designing the workflow rest.

Regards,
Nived N
Happy Automation

7

it doesn’t work can you provide me with sheet to understand what you mean

8

dt2=dt2.DefaultView.ToTable(True,“order”)
error with that variable

9

U can add ur sheet as input there

10

Sorry it should be

dt2= dt1.DefaultView.ToTable(True,“order”)

11

ask.xlsx (11.0 KB)

12

Hi @rpa13
try this workflow
ask.xlsx (11.0 KB)

Main.xaml (13.9 KB)

13

you may not understand me as i will get unknowen number of orders

14

I did not understand ur requirement well

15

sheet
sheet708×507 45.6 KB

enter the sku’s with same order number (example order no 154) and save them , then
enter the sku’s with same order number (example order no 155) and save them and so on
@NIVED_NAMBIAR

16

@rrenu59 @Adrian_Star if you can please help in this thanks in advance

17

Hi @rpa13 !
Here is a suggestion:
Condition_on_excel_sheet.xaml (12.9 KB)
Don’t forget to adap your read range with your filepath and sheet name.

To understand more, I recommend you to use debug mode. I have left on purpose breakpoints in strategic points. Each time the robot does a break, in the local panel, watch carefully the variables sku, increment_id and temp_DT.

image
image1429×787 61.7 KB

To write in the right line in All items table (in your website), do you know how to do ?
If no, use UiExplorer and indicate these elements and send us a screenshot of what you see:

image
image1796×478 41.8 KB

and indicate the following fields (so we need 2 screenshots):
image
image418×518 44.3 KB

18

i got this error

error
error1221×543 35.2 KB

19

Using exactly the same data you sent us as a screenshot (the 3 columns + 4 lines) ? with my sample it works:
image

20

Can one order_ num have more than one incrementID?? Only sku differs with every combination of order_num and increment_id right?

21

I checked the flow of @Hiba_B and it works well. :slight_smile:

When working with Sheet4, you need to customize the column names in the workflow.

Column order_number to order.
Column sku to *product

image

2 Likes
22

no ,every order number has one increment_id with differ sku and qty

23

ask3
ask3639×510 18.7 KB

i try to put each order example in screen shoot i add qty colom in my sheet
as i work on sap system not website
Condition_on_excel_sheet.xaml (39.1 KB)