Hi All,
I have a excel sheet that takes in an excel with 3 columns as input(Id,age,interest),this will look up to another excel sheet with 2 columns(Id,name) and should create an output file with(name,age,interest) coulmns.Can someone please help me out to do this usecase.
@Navya Normally we would need to have a Key Value to match the rows of the First Excel with the rows of the Second Excel and Produce the desired Output. So if you can provide the Key Column that needs to be provided to be matched in both the Excels, we can suggest a Solution. Or If you Provide us with a Sample Input Data and the Expected Output, it would be faster to Solve it
@Navya In the Given Excel The Id 67 maps to Music, and in the Other Sheet the Id 56 maps to Vignesh. The Output Sheet has an irrelevant mapping to Vignesh and Music. Is it a typing mistake or is the Output as it is? Because in the Output Sheet there Should be No row for Vignesh as there is no proper mapping.
@Navya Ok. But what if there are rows in Sheet1 with Id which are not Present in Sheet2 as well as other rows which do not have a match. What will be the Expected output in that case ?