Hi Team, I wanted to exclude records where the rec create date of feature schema is less than then broad log event date. There was a join between recipient schema and feature schema. First I tried querying the recipient delivery logs by keeping rcipient as target dimension and then later added one m...

Hi Team,  I'm utilizing a data loading function with a date column in the format dd-mm-yyyy. Although I've chosen the format as dd/mm/yyyy and set the separator to "-", it's returning zero results. Is there a method to convert the data to dd/mm/yyyy after the file is loaded? Please advise.  Thank yo...

Thank you @ParthaSarathy , this was working but I have used a different column that has unique values and can see the latest record being picked up.  

Thank you @LakshmiPravallika , Upon attempting the solution provided earlier, I encountered the following error:The column "tablename.REC_CREATE_DATE" is deemed invalid in the ORDER BY clause due to its absence in either an aggregate function or the GROUP BY clause. Please suggest

Hi Team,  I aim to select the records with the latest creation date. Suppose there are six records with unique IDs but identical customer names, each with distinct creation dates. Is there a method to choose the most recent record based on the creation date? Thank you in advance

Hi there,  I'm experimenting with implementing a one-click list unsubscribe feature by incorporating the following code into the Additional SMTP header:List-Unsubscribe-Post: List-Unsubscribe=One-Click List-Unsubscribe: <unssublinkfromwebapp?id=<%= recipient.cryptedId %> >, < mailto:<%@ include opti...

Hi There,  Can we retrieve data from a Google Sheet and incorporate it into the team table within a workflow for exclusion purposes? Additionally, considering this is a dynamic list where new records are added daily, what would be the best approach to accomplish this? Thank you in advance.

Hi there,  Could someone help me understand the error below? It's happening in a specific workflow when I attempt to restart the workflow from the Fork activity. Interestingly, this error doesn't occur in other workflows when I try to restart them from the Fork activity. Thank you in advance 

Hi @LakshmiPravallika , I'm interested in downloading all the available image files rather than just the metadata. Could you please inform me if there's a method to accomplish this via API or by importing it as a package? Thank you in advance.

Hi Team, Could all the data within the public resources, including subfolders and individual files, be exported using a query activity & Export activity? Alternatively, is it achievable through an API call? Your suggestions would be appreciated. Thank you in advance.   I'm observing the count, but h...