Read current and next row and if it has same id write both row information

Help Studio
, ,
1

MyFile.xlsx (9.8 KB)
My excel have 2 same ID but description is different and sallery is based on description.

How can i read next row and if it has same ID then write both the first ID and same ID data together into field.
So that I can create one case on user and add both row information into one case.
help please.
@ppr @supermanPunch

2

@Latif Can you show us the Output for that Input file? How do you want the data to appear in a Single row ?

3

output will be like… I will add both current and next row data together.
image

and then it should go further with next ID. means it will come to skip one row as It has already read that.

4

@Latif If you can provide a Output Excel file for the Sample Input file that you have given, it would be better :sweat_smile: Otherwise I would have to ask you questions in a repetitive manner.

5

MyFile.xlsx (11.8 KB)
hope you got it…
But I have to put this data not into Excel but into ServiceNow…

6

@Latif Check this Workflow :
GroupByCountAndConcatenate.zip (9.0 KB)

This will work only if the Header formats are the same.

7

thanks but i need to do this in uipath way as if else statements :frowning:

8

kindly help @supermanPunch

9

@Latif May I ask why do you need this approach :sweat_smile:

10

because i have to use the data into ServiceNow and close ticket if the next row is not same… and if next row is same as current row then I need to append the current row data into same ServiceNow ticket.
So that I do not create a double ticket on person name…

11

Hi @supermanPunch
kindly help me on that post too…
I created this if statement to solv this problem…

image

2nd IF is this:
DataTableExcelSheet.Rows(RowCounter)(“MA-nummer”).Tostring = (DataTableExcelSheet.Rows(RowCounter+1)(“MA-nummer”).Tostring)

But i’m stuck in how can i collect both 1st row and 2nd row colums data at the same time. means rest of the columns data…

so that i prosed with data in Then and add to the case one time…

12

superman kindly help…
@Palaniyappan can you help on that please…