1 of 1 people found this helpful
ExecuteSQL("SELECT DISTINCT(clientEmail) FROM transactions";"";"")
just grab the results out of your data viewer since it's a one time thing.
Mike, you may want to add a record delimiter if using executeSQL to get all values. And then there is the "old school" method of creating a value list with all values entered in that field, then get the value list items with a calculation, that also works.
But for your case, you might just need to export a list of unique email addresses, you can just sort by email address and export records, making sure to check the box to summarize by the email field and you will only get one record exported for each value.
When using ExecuteSQL with the record delimiter parameter empty, it uses the default of a carriage return, which is already perfect for parsing through with the GetValue function.