Mapping

[Yogita_Gaikwad]

excel first
Ship_State | color | Ship_To_City | Amount | Invoice_Date | Quantity

maharshtra | red | mumbai | 10 | 20-10-2022 | 3
karnataka | green | krntka | 20 | 22-10-2022 | 4
goa | blue | Aurag | 30 | 23-10-2022 | 5

excel second

ShipState | product | ShipCity | Amt | Invoicedate | Qty

hydrabad | nskkk | mumbai | 11 | 10-10-2022 | 10
saputara | puneee | krntka | 22 | 12-10-2022 | 20
west | mum | Aurag | 300 | 13-10-2022 | 30

can i done mapping for this ex.ship_State & ShipState record go in one one column like this
output::
Shipstate | Shipcity | Amount | Invoicedate | quantity| color | product
maharshtra | mumbai | 10 | 20-10-2022 | 3 | red | nskkk
karnataka | krntka | 20 | 22-10-2022 | 4 |green | puneee
goa | Aurag | 30 | 23-10-2022 | 5 |blue | mum
hydrabad | mumbai | 11 | 10-10-2022 | 10 | |
saputara | krntka | 22 | 12-10-2022 | 20 | |
west | Aurag | 300 | 13-10-2022 | 30 | |

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @Yogita_Gaikwad
Have you try Full Join?

[ashokkarale]

Try to follow below steps:

1. Use activity Read Range to get the data from first excel file to a DataTable variable e.g. dtFileOne
2. Use activity Read Range to get the data from second excel file to a DataTable variable e.g. dtFileTwo
3. Use activity Merge Data Table to merge data tables

Your workflow will look like this one.

I hope this will be helpful.

[Yogita_Gaikwad]

if column name is different first excel SHIP_TO_City & in second excel shipcity

i want only get match column record