Merging DataTables

Help Studio
, ,
1

Question has been deleted since
Edited the question as no solution got so far

Grateful for any kind of help
Thanks

2

Hi @Pranay_Kumar_Bose ,
I understand is
1.merge input1 and input2
2update in main
that’s right?
but I see “Employee Name” and “vertical” in input1 and input2 are similar ,
what is condition to merge?
regards,
LNV

3

Need to put the data’s in “reason” and “Additional comments” from input1 and input2 to main.xlsx file… There is no data in “reason” and “Additional Comments” in the main.xlsx file…

4

I want to put the data in “reason” and “Additional comments” from input1.xlsx and input2.xlsx to main.xlsx file…
As there is no data in “reason” and “Additional Comments” in the main.xlsx file…

Actually, there are few more excel files same as input, but here I have uploaded only 2 input files.

I need to check for “Employee Name” and “vertical” to check for similarity and then update the cells in main.xlsx under “reason” and “Additional Comments” .

5

Hi @Pranay_Kumar_Bose ,
I understand put the data’s in “reason” and “Additional comments” from input1 and input2 to main.xlsx file
But some “Employee Name” and “vertical” are not similar, I want to know if they are not similar, what do I need?
regards,
LNV

6

We can just put a message box for that…

7

I need some idea
@Nguyen_Van_Luong1

8

Hi @Pranay_Kumar_Bose ,
I think first, we need compare input1.xlsx and inpu2.xlsx
that is right?
check “Employee Name” and “vertical” in 2 files are same → get “reason” and “Additional Comments” in input1 or input2 to main

My question is

  1. “Employee Name” and “vertical” in 2 files input1 and input2 are same the same,
    but “reason” and “Additional Comments” in input1 or input2 are different? -->Does this case exist?
9

Check for “Employee Name” and “vertical”,
IF
“Employee Name” and “Vertical” in Input1 = “Employee Name” and “Vertical” in Main
{
Copy respective “Reason” and “Additional Comments” from Input1 to Main
} else
{
message Box - Values mis - match
}

IF
“Employee Name” and “Vertical” in Input2 = “Employee Name” and “Vertical” in Main
{
Copy respective “Reason” and “Additional Comments” from Input2 to Main
} else
{
message Box - Values mis - match
}

Answer to your Question - The “Reason” and “Additional Comments” are different for each employee name.
Input1 and Input2 and Vertical data’s received from different SPOC’s. The “vertical” name Infront of each “Employee Name” is Same…
Also the “Employee Name” and “Vertical” is same in all the 3 xlsx files… I need to merge the Last two Columns i.e “Employee Name” and “Vertical”

The “Employee Name” and “Vertical” are like Primary Keys, the process should go ahead only after checking of the Primary keys.

Please let me know if any additional Information is needed…

Thanks

10

Hi @Pranay_Kumar_Bose ,
I will try then send to you

1 Like
11

Since no solution got so far… marking this reply as solution for thread Closure.

12

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