Good morning ,
I am using Studio X and I am facing a problem with a SAP data table.
I have several rows from , mostly from 5 to 10 and usual the last two rows should be deleted, it depends if the value is a special amount, direct in SAP.
So first I have to find out if the amount is in the line and then this line should be deleted. could you help me how to find out which are the rows and how to mark it to delete?
thank you in advance !
Could you please show the same in screenshots please ?
Hello @christian1 ,
Plz confirm whether the rows to delete is static or give more explanations to get the rows to delete.
Also is there an option to filter the rows in SAP available?
Hello, I have already get it to use a variable selector to delete the certain lines that works with variables.
But now i have another open question.
I have a repeat number of times activity and this activity should be executed as many lines my purchase order has and should type into a special Value in each line.
I have already managed to address each line when I specify the value e.g. 0 for line 1 and 1 for line 2 but the loop should increase the value. how can I set that I assign a variable a value at the beginning and then increase by +1 until I have reached the number of repetitions?
You are specifying it in the
Type into selector right ?
You can just take the
For-each output which will give you that index count and automatically increment as well.
Hope this helps.
yes, thats right I specify it in the type into selector, but I dont know the for each output/activity and in SAP the table row starts with 0.
Sorry for the wrong name mentioned
You are already using
Repeat Number Of Times that’s the one I’m talking about.
Sorry, I dont understand what you mean
I send you my workflow
at First i extract the table the receive the value rows i have to fill in
then I specify a variable with the count rows.
then I have the repeat number of times, with the repeats of my variable
and in the selector variable I start with 0 because SAP lines start with 0 for the first
and this is the problem the selector variable is a string and it is not possible to convert it or something else to increase the value from 0 to 1 , type into , 1 to 2 , type into …
Sorry, I’m a bit confused here…
You want to just pass a counter right ? I think that is already implemented by you.
So what’s the issue
I am sorry, I hope i can explain it clearly.
The repeat activity and the repeats itself work fine.
But in the body of the repeat I have a type into activity and this type into activiy should click on the first SAP line in repeat 1 , but the first SAP line is in the selector 0 , so I need a new variable which starts with 0 and could be used as a selector variable. After the first line is filled , the variable should increase by one which also means that this is the second SAP line where my type into activity works, and so on until all my SAP lines are filled with the necessary information.
So the key is how to create a dynamic variable which is increasable. In the repeat activity its not possible because this is only a string format and I can not convert it to make it increasable.
thx for your help and support
Okay I think I’m able to get it now. Check the below steps,
So the first step is the initialize a number variable with
0 (Make sure you choose
Number in the
Save for Later activity as shown in the dropdown in the above snap)
Then add an
increment logic inside the repeat after the
Hope this helps.
Thank you so much, I think thats nearly what I am looking for.
I promise this will be my last question
I specified the variable as you posted it
could you help me how to send this variable to the value mappings in the repeat acitivity ?
its is not possible to convert it to integer , but this value is important , this value is the only one I can use in selector variable
No worries, you can raise any query any no. of times
So you mean you are unable to insert this variable into the selector ?