How to map from one excel to another excel sheet

Help
,
1

i want to map from excel1 to excel 2 based on the column s

can anyone do the needful

2

@haria05a7 u want to add data from excel 1 to excel 2. Is it Correct?

3

Thanks for ur reply.
No, data will be there already in the excels .just i want to map both the columns in the excels sheets .
if matches both the values correcty.
i want the total number of hours count both the sheets .

DATE WORKING HOURS
1-Oct-18 8
2-Oct-18 PH
3-Oct-18 8
4-Oct-18 8
5-Oct-18 8
8-OCt-18 8
9-OCT-18 8

are the columns in excel 1

Rpt Dt Quantity
10/1/2018 8.00
10/3/2018 8.00
10/4/2018 8.00
10/5/2018 8.00
10/8/2018 8.00
10/9/2018 8.00

are the columns has to map whether it is right or wrong if matches it go for next

4

@haria05a7 Check the below workflow.

new11.xaml (13.7 KB)

5

there i want to add all 8’s in excel 2 and it equals to the number of hours in the excel 1

finally it has to match excel 1 and excel 2 working hours both are same or not

6

@haria05a7 Check below workflow.

new11.xaml (16.7 KB)

7

image
image1920×1080 185 KB

am Getting this Exception while running with my original excels sheets

And i want to get the data from excel 1 total number of hours ,total of working days and leaves columns into new excel sheet .

8

@haria05a7 expception will occurs at that time, it may be due to PH or empty value, that’s why i kept that statement in try catch block. But workflow stopping at that point and giving such options. Alternate to it, Replace try catch block with if condition, In if condition check obtained value whether it is numeric and not null value. If it is true, convert that value to integer and assign that value to totalhours1 variable, If condition is false assign 0 to totalhour1 variable.

9

@Manjuts90 thanks for ur reply .can send the updated work flow .am getting the exception there and

And i want to get the data from excel 1 total number of hours ,total of working days and leaves columns into new excel sheet .

10

@haria05a7 try below workflow.

new11.xaml (16.1 KB)

12

@haria05a7

we are just counting total number of hours from both excels and comparing that total count whether they are equal or not. we are not counting Number working hours , Number of Working Days , Number Of Leaves in that workflow.

13

@Manjuts90 After couting or mapping(checking ) i want Number working hours , Number of Working Days , Number Of Leaves, in different excel sheet than it has count N number excel sheets but am getting this error

image
image1920×1080 175 KB
these are the excel am working

14

@haria05a7 Can u upload ur workflow?

15

Main.xaml (35.8 KB)

17

@haria05a7 Check below workflow.

excel.zip (39.6 KB)

19

@haria05a7 Same thing i did in that excel zip check it once

20

@Manjuts90 but It Couting A , PH , T .whever these are avilable it count as zero

now i sent excat excel sheets can u open and u will know drop list items

if excel sheets completes it shows the both values wherther it matched or not than it has to go next excel2 sheet

21

@Manjuts90 .now every thing fine only one thing .in excel 1 matches the count with excel 3 than excel 1 is finished

again it has to count excel 2 with excel 3 with the respective name or ID can u do the need full thing

22

@haria05a7 workflow is checking both excel 1 with excel 3 and excel 2 with excel 3. Please check the workflow once thoroughly

23

@Manjuts90 workflow is checking both excel 1 with excel 3 (dump file) than it continuing like that only but i want once it finishes checking both excel 1 with excel 3(dump file) than it has to check excel 2 with excel 3 separately like one after the from initial step like 8 both 8 matches than again it has to count from zero to excel2
other excel sheets