Get Field/Set Field/Parent Folder - What do they do?

Arrays is good word , JSON supported , clear with SQL , Postgres and more. 

Lists are known in PowerBI , Sharepoint 

When Deduping , also give an option to remove blanks !! MS SQL is notorious for not doing distinct string aggregation in a simple way

Here it is as promised

29/01/2026 6.4.6.56

 + Added: Sort Delimited Values Transformation function
 + Added: Deduplicate Delimited Values Transformation function



It is hard to believe but Advanced ETL Processor has more than 550 transformation functions now 

Congrats on 550 !!

Although deduplication is being done but delimiter is not being removed

1. If my input is STOCK,STOCK    then my output is Stock, which should be Stock 
2. if my input is STOCK,STOCK ,324034, 324034 , then my output is Stock,324034, 

In both cases one delimiter extra is present , which isn't the desired case when deduplicating 

IN an edge case , my input was (with space in beginning)
      33510,     33510,     33510,     33510,STOCK,     33510,     33510,     33510,     33510,STOCK,     33510,     33510,     33510,     33510    

I used trim but the output still has the space in beginning , see photo 
 

Nothing wrong with that, you can get rid of spaces by using Delete Characters Transformation Function

www.etl-tools.com/wiki/advanced-etl-proc...s/delete-characters/

Fair enough , I will use Delete Characters Transformation Function

I look forward to having extra delimiter removed.