Change x column "String to Date/Time in one operation

Hello again,

Very simple....perhaps !!!

A receive 15 column (String) and must them changed to Date

It will be not nice to reapeat 15 time the node

I try with Loop.....but without success...

 

Many thanks in advance

MitchP 

You can you use a Column List Loop Start/End construct to process on column at a time. Your probably need to uniquify the column: use the Column Name (Regex) to create a "default" column name for each column and do the rename straight before the Loop End.

Hi Gabriel,

Many thanks, i did it this way :

Column List Loop Start

String to Date/Time with Variable (ColumnName)

Loop end (Column Append)

but very Time and Memory consuming....

MitchP