How to consolidate the excel rows which contains multiple data of same employee into a single row

i have an excel sheet which i have read into a data table . I have to compare the dates present in that and fetch the values under it.

eg:
empid name date1 date2 date 3…
123 xyz p
123 Ab p

my final o/p should be like:
empid name date1 date2 date 3…
123 xyz p ab p (in a single row) under the same column.

image= input format

image = output i need to obtain
can anyone help me on this?

read the excel file and then you will get datatable right and then read second file and then use merge datatable activity to merge .

there are multiple rows present we have to get in single row

okay …then use get row activity

i get values using get row item but the values come in different rows

if you used the get row activity you will get only one row right how you are getting multiple rows

@sandeepbht96 Check below file once.

Test.zip (160.3 KB)

1 Like

Thanks a ton.It worked.

1 Like

@sandeepbht96 your welcome :slightly_smiling_face:

these are not mapped to the columns present in the datatable .if random datatable is used also it starts from other cell only.
for eg company id column is before employee_id then the employee id values are printed on company id.Could you help me over this?

@sandeepbht96 Can you share sample excel file and along expected output? It will be helpful for better understanding

company id xyz1 xyz2 xyz3 eid payscale name date1 date2 date3 so.on
(blank) (blank) (blank) 123 (blank) xyz p (blank) (blank)
(blank) (blank) (blank) 123 (blank) (blank) (blank) ab (blank)
(blank) (blank) (blank) 123 (blank) (blank) (blank) (blank) p

= input given

company id xyz1 xyz2 xyz3 eid payscale name date1 date2 date3 so.on
123 xyz p ab p

=Output It has to be

@sandeepbht96 Please check below file. let me know if you have any doubts.

Test.zip (160.6 KB)

Thanks a ton.It worked fine.

1 Like

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