a node that can change date cell format?

KNIME Analytics Platform
1

Hi 

I would like to to join two data tables , the identifier is the date with the following format  yyyymmddhh (example 2016091203) but in one of the tables the format is different (yyyy-mm-dd-hhhh ) so, is there a node that can help me change the format.

Thank you 

2

Hi Kibrom,

Prior to Joiner node, use String to Date&Time node with both tables. This node will help you to convert the character representation of the date into "date&time" format, which would then serve you as unique identifiers. In configuration window of String to Date&Time node, go to "Type and Format Selection" dialog and in "Date format:" specify (just type in) the date format in your table. E.g. in the first table it should be yyyymmddhh and in the second one yyyy-mm-dd-hhhh. Afterwards, in Joiner node use these newly generated date columns as the unique identifiers of the tables.

Check these two posts for more information (string to date, time series functionality) .

Hope it helps!

Best, Daria

 

 

 

3

Thank you Daria,

I try to use the " String to Date/Time " node since the date column  in my tables are the Row IDs so I could not see them on the list of "Selection Column" .

can you please advise.

 

thank you 

 

 

4

You can use a RowID node to create a new column containing the row IDs.

5

Hi,

The problem was that the date was the default row ID and now when i deselect the " read row IDs" on the imported file configuration, the system gave a new row ID (Row 0, row1, row 2 etc) to the table so now when i used the "string to date" node i can see the date column on the list and i can convert the format. 

 

thank you all

6

Hi! Where is “Type and Format Selection”?

%D0%94%D0%B0%D1%82%D0%B0%20%D0%BE%D1%82%D1%87%D1%91%D1%82%D0%B0
%D0%94%D0%B0%D1%82%D0%B0%20%D0%BE%D1%82%D1%87%D1%91%D1%82%D0%B0797×774 89.4 KB

7

Hi @Goger -

It’s the bottom section here:

TaFS

2 Likes
8

Hi,
I have the following date and time format: 2020-08.06T10:29:18Z (from msg-filges).
How can I change this format to dd: mm: yyyy, HH: mm: ss?

Thx in advance!

9

Hello @USCHUKN1ME,

guess you have your dates in string column. If so use String Manipulation node to and substr() + join() functions to get your desired format.

Br,
Ivan

10

Hello Ivan,
thank you for response.

I used first the Cell splitter by position and then the node String Manipulation four time.
It works :smiley:

regards Uwe

1 Like
11

Hello Uwe!

Glad to hear you found a way :slight_smile:

Br,
Ivan