Hi i need help related to excel data manipulation
so this question related to this;
So guys i want to ask how to process this data table,
main objective
1.Seperate Datatable based on Combine (A1,A2,NO COMBINE)
2.Process data based on seperated table
3.append all the result to 1 table
4.the vaariant doesnt affect the sperating of table , lets make it the type into value
5.reports column should be all have value on the new combined data table
the process can be simple type into , i just dont know hot to do this workflow properly
original Data
[image]
2.Seperated Data A…
After seperating the table i encounter new problem on the processing of seperated table
i have question on :
how to append new value for the RPA remarks based on a uniq reference from the table,
example:
original table
then i do some process and have value of : “success”
I NEED TO HELP to get the output value of “succses/variable” to APPEND to a spesific row based on “uniq row”
example last excel output with a UNIQ ROW:2 and "variable string = success " to append to original table
thank you and regards
HI pravin sorryb , kinda hard for me to explain in english,
you can refer to my related question here
Hi i need help related to excel data manipulation
so this question related to this;
After seperating the table i encounter new problem on the processing of seperated table
i have question on :
how to append new value for the RPA remarks based on a uniq reference from the table,
example:
original table
[image]
then i do some process and have value of : “success”
I NEED TO HELP to get the output value of “succses/variable” to APPEND to a spesific row based on “uniq row”
example last ex…
Hi @Ahmad_Rais
try out this syntax
if currentrow(“uniq”).ToString=2
{
Currentrow(“reports”)=Currentrow(“reports”).ToString+Environment.NewLine+Variable
}