combine multiple fields from one table into one main field

BeastMode

hi everyone!

I'm working with a dataset in which every new transaction creates a new 'transaction date' field as oppose to keeping the dates within one field. see sample attached. I'm trying to figure out how to combined the fields 'transaction 1 date' thru whatever the number of transactions may be, into just one 'transaction date' field. any ideas? i appreciate any help. thanks,

MarkSnodgrass

You should be able to do this with the Collapse Columns feature in the ETL. Here is a link to the KB article that walks you through how to do it.

https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns#Collapse_Columns