QuestionQ82Verified/Scripting and AutomationCopy linkReport a problemAsk AstroTutorSave questionWhy might a developer use LookupRows rather than the Lookup AMPscript function?ATo return a complete rowset from the data extensionBTo access a data extension, as Lookup only targets listsCTo see how many rows are in a data extensionShow AnswerAnswerExplanationLookupRows() returns an unordered rowset of the matching records from a data extension, whereas Lookup() returns a value from a specified column and returns only the first matching value when multiple records match. This makes a rowset necessary when the matching rows and their fields must be accessed. Salesforce: LookupRows()Learn moreSalesforce AMPscript LookupRows() referenceSalesforce AMPscript Lookup() referenceShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion