Hi , I am pulling the fields from SQL into Adobe in which Email address is in BINARY 64 as data type , which is creating issue in reading the email field in Adobe campaign. How can I convert the data type Binary 64 (data type is showing as BIN in Adobe) for email field so that I can join this BIN data type with my other email column whose data type is STRING.ThanksArif

Hi Team, I am trying to build one predefined filter for max(value) for each household, same thing I have achieved through QUERY process box, where I am utilising the Aggregate functions and doing group by on Household key. Now when I am trying to achieve the same through predefined filter I am not sure how exactly I can achieve, I am doing something like below but then questions comes for how to do group by.