I Got this scenario in one of the interview ,
i had given two excel files
one was the YOB.xlsx where it contained empid,fname,lname,yob,gender
gender column didn’t had any data
second was Gender.xlsx where it contained empid,fname,lname,yob,gender
gender column had data
what should be the approach for these type of questions?
thank you for solution i have removed duplicate rows and created folder for each year but not getting how to proceed further can you help me with workflow?
@NIVED_NAMBIAR Can you help me with this?
Check the workflow
I think this is the exact that you want
excel.zip (101.7 KB)
Hope it helps You
Mark it as solution if it helps
Thank You @NIVED_NAMBIAR It works fine.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.