Forum Discussion

pranil2k2's avatar
pranil2k2
Contributor
5 years ago
Solved

Get minimum date from set of column values

Hi, I have a typical requirement, where i need to find the Min ETL run time from below set of data. I tried to convert rows into columns but there is no common field to do group by. i tried differ...
  • bojanvelevski's avatar
    5 years ago

    Hi @pranil2k2,

    I’ve attached a pipeline that can help you with this requirement. If you don’t want headers to be written in the file, uncheck ‘Write CSV header’ option in the Excel Formatter.

    Row_to_Column_2021_05_13.slp (7.5 KB)

    Here’s the result:

    Best regards,
    Bojan