How can I compare item SAP and Excel by selected some item inline (SAP) for an update?

Help StudioX
, ,
1

Hi,

please advice me about UiPath, if I want to update data by selected item in line that same as the item in excel file and update only the Qty number in SAP. Sample: Find and Update only the item 5LS02BD2206G0000 = 30 (in excel) from number 40 in SAP (column M 02.2021) etc.

image
image949×457 39.9 KB

2

Hi @Supot_Punchuen ,

Please help me understand better. Are you saying to change the Excel value from 25 to 40?

image
image909×452 163 KB

3

Hi GreenTea,

Sorry for the late reply.
From the figure, I need to change data in SAP from 40 to 25.

4

Hi @Supot_Punchuen ,

First you need to use UiExplorer to examine the selectors inside the SAP table. See this post for reference.

After you have correctly ascertain the selector that uniquely capture the cell “40” for column - M 02.2021 and row - SLS02BD2206G0000, you can use activity “Type Into” to replace the value from “40” to “25”

5

Hi @GreenTea,

Thank you for helping me with this issue.
I can solve it already.

Sincerely yours,

6

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