How to match data in data table?

Help
, , ,
1

I have a data table like this

image

image

I want output like this

image

I created join but the column in second dt will keep varying so how to do this?

I want to put that comp amt exactly under that in the first table… but cant use build dt since it keep varying… how to do this ???

kindly help…

2

Use Merge Datatable as Emp No is the same.

2 Likes
4

In the second table the cols will keep varying so will merge work?

I tried using join dt but its not effective…

5

@lakshman @Palaniyappan

1 Like
6

Hi @cybzom

yes it will merge use merge datatable activity

Thanks
Ashwin S

2 Likes
7

I think perhaps they meant the Join Data Table activity. The only thing to note is that the emp ID column will be show up as a duplicated column after the join. This can be solved with the remove data column activity.

Cheers

3 Likes
8

Merge will work as long as both datatable have a reference column i.e. Emp No stays the same, all other columns will then join together if different.

2 Likes
9

Won’t it remove the first column as well?

10

I will try it, thanks Tim :smiley:

1 Like
11

No, you can reference by index which column to remove