Icon

KNIME_​extraer_​strings

your dataONLY.xlsxsubstracttime from Pathformattimeformat_Time_ to 'T'addsecondsNode 8Path formatRead your dataimagine thisis your datafrom Excel Readeroutput portaddsourceaddtime_textcollectdata readiterationsResort columns as you likeTable Creator Row Filter String Manipulation String to Date&Time String Manipulation String Manipulation Table Row ToVariable Loop Start String to Path(Variable) Excel Reader Table Creator ConstantValue Column ConstantValue Column Loop End Column Resorter your dataONLY.xlsxsubstracttime from Pathformattimeformat_Time_ to 'T'addsecondsNode 8Path formatRead your dataimagine thisis your datafrom Excel Readeroutput portaddsourceaddtime_textcollectdata readiterationsResort columns as you likeTable Creator Row Filter String Manipulation String to Date&Time String Manipulation String Manipulation Table Row ToVariable Loop Start String to Path(Variable) Excel Reader Table Creator ConstantValue Column ConstantValue Column Loop End Column Resorter

Nodes

Extensions

Links