Hi ,
i have a requirement where i need to check values in an array ,if exists then update cdt or else create a new cdt.
Consider
local!A: {"AA","BB; CC"}
local!B: {"BB","AA"}
if exists update
not exists create
here i need to compare every item in local!A eg:("BB; CC" ) with local!B,since BB exists in local!B, i need to update BB to "BB; CC" and vice versa.Every item(AA,BB,CC) is unique and will not repeat in an array.
please provide your suggestions.
Thanks in Advance,
PradeepB
Discussion posts and replies are publicly visible
Is that a check for equality of the element that you want to do? From your elaboration it seems like you want to check whether an element in B is contained within a string in A, as well.
Marcel Paradies Thank you for your reply.Yes i want to want to check whether an element in B is contained within a string in A, as well.
difference(array1, array2)
Returns the values in array1 and not in array2.Then append the missing ones