Hi All,
I need help in understanding how to map two column values of two different excel sheet. Below is my use case.
I have two excel sheets: Quote number is a common column . I need to check if In Unmatched sheet any Quote number has value(PaymentTerms) in Mismatched Data column then it should pick the Payment terms value of that particular quote number (suppose Net30) from the Output sheet . How can I map these two excel sheet column values
Till matching data with quote number is file…what is it about mismatched and payterm?
Can you show some output with example
Cheers
Actually in the UnMatched Sheet, for QuoteNumber Q30564 (Column Name -Mismatched Data) we have Payment Terms , Contract Value , Primary Contact.
In my case , If the value “PaymentTerms” is there in Mismatched Column, for whatever Quote number(In this case its Q30564), then it should pick the corresponding PaymentTerms value i.e.Net30 from Output sheet of same Quotenumber Q30564(IN THIS CASE ) and update in application.
Basically since I need Payment Terms value from “Output Sheet” Column Name (“Payment Terms”) since Payment Terms is there in Mismatched Column in UnMatched Sheet
Whenever Payment Terms is coming under Mismatched Column , I should get that Quote Number and Payment Term value from Output Sheet
@Anil_G any help on this
