I need to Update my data through Azure data factory with Some Condition

%3CLINGO-SUB%20id%3D%22lingo-sub-2499875%22%20slang%3D%22en-US%22%3EI%20need%20to%20Update%20my%20data%20through%20Azure%20data%20factory%20with%20Some%20Condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2499875%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Two%20Columns%20Claim%20Status%26nbsp%3B%20and%20Offer%20ID%26nbsp%3B%20the%20scenario%20is%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20having%20data%20in%20Excel%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3Bwe%20are%20having%20some%20old%20OfferId%20and%20New%20Offer%20ID%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20there%20is%20Offer%20ID%20is%20already%20available%20in%20the%20system%20then%26nbsp%3B%20do%20not%20need%20to%20update%20the%20Claim%20Status(Consider%20the%20old%20Claim%20Status)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20it%20is%20new%20create%20the%20new%20entry%20with%20OfferId%20and%20Claim%20status%20.(That%20Is%20completed)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2502690%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20Update%20my%20data%20through%20Azure%20data%20factory%20with%20Some%20Condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2502690%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1058949%22%20target%3D%22_blank%22%3E%40v-ppurwar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%20Community%20Discussion%20space%2C%3C%2FA%3E%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-data-factory%2Fbd-p%2FAzureDataFactory%22%20target%3D%22_self%22%3EAzure%20Data%20Factory%20space%3C%2FA%3E-%20please%20post%20Azure%20Data%20Factory%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

I have Two Columns Claim Status  and Offer ID  the scenario is 

 

 

We are having data in Excel 

 we are having some old OfferId and New Offer ID 

If there is Offer ID is already available in the system then  do not need to update the Claim Status(Consider the old Claim Status)

 

If it is new create the new entry with OfferId and Claim status .(That Is completed)

 

 

1 Reply

@v-ppurwar 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Azure Data Factory space- please post Azure Data Factory questions here in the future.