Get minimum date from set of column values

[pranil2k2]

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 different options but nothing worked for me

The desired output is like report name and time

Please some one can advice here.

Thanks

[bojanvelevski · Accepted solution]

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

[pranil2k2]

Hi bojanvelevski,

Thanks for the reply. I too tried Group by N snap but i forget as we can read the columns using index path. Now to get my output i need to do group by on some column, but now we dont have any column to do, i tried using Aggregate snap as i cant group by i got only date output but i need file name too. any advice here.

The output should be as below. Thanks

Thanks

[pranil2k2]

Hi,

I just added one dummy column and used it in group by function. finally i got the desired output.
Thanks a lot for the input, it helped me a lot.

Thanks