Add new input into Data Table with for each row

Help StudioX
1

Hello all,

i have the following process:

I have a Data Table which looks like this

Number l Quantity l Place

Only the column number is filled.QUantity and Place is empty. With the number I go into SAP and Extract the quantity and the place. So for each row that I do that with I want to add this data into the data table into the rows i got the number from.

Do you have any suggestions?

2

Hi @VLC

You could use For Each data row, then perform the necessary extraction and then use assign:

currentRow("Quantity") = yourValue
currentRow("Place") = yourValue

Example:

INPUT:

This image shows a "Build Data Table" interface with columns for Number, Quantity, and Place, with the Number column populated from 1 to 5. (Captioned by AI)
This image shows a "Build Data Table" interface with columns for Number, Quantity, and Place, with the Number column populated from 1 to 5. (Captioned by AI)488×336 7.33 KB

Workflow:

A workflow interface showing an iteration over a data table with assignments updating "Quantity" and "Place" fields, and a breakpoint set. (Captioned by AI)
A workflow interface showing an iteration over a data table with assignments updating "Quantity" and "Place" fields, and a breakpoint set. (Captioned by AI)867×519 25.2 KB

I ran it for one iteration, As you can see in the Immediate Panel, the data is added to the row.

If this solves your query, Do mark it as a solution
Happy Automation :star_struck:

1 Like
3

Without knowing all the details of your process, it sounds like you’re approaching it backwards. Why wouldn’t you just start with an empty datatable, and populate it with Add Data Row as you loop through the data from SAP or use Table Extraction?

1 Like
4

Hi Paul,

I extract the Number column from a diffrent SAP transaction and then use those numbers to get more data in another SAP transaction.

Otherwise I agree loping through it would be th ebest option

1 Like
5

Hey @VLC

Did you try my solution?

6

Works like a charm :slight_smile:

1 Like
7

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