Get week number

KNIME Analytics Platform
1

how can i creat week number?

2

String to Date&Time and Extract Date&Time Fields

br
Andrew

4

I can’t use string to date&time node, because date format of dataset :
Thu Feb 06 18:19:17 +0000 2020
ERROR String to Date&Time 0:11 Execute failed: Failed to parse date in row 'Row0: Text ‘Thu Feb 06 18:19:17 +0000 2020’ could not be parsed at index 0
How am I to get it?

5

Hi @fateme,

could you tell us you need both date and time or only date? When you are converting from string to date, output format also need to be looked into.

we have multiple ways to convert this. if you need only date, you can extract only the required part by using substr/regex/len functions in string manipulation node then convert to date.

hope this helps you… :slightly_smiling_face:

Regards,
Pavan

1 Like
6

Hi pawanmtm
i need date. and then switch date to weeknumber

7

You will help to write this example.
Thank you.

8

Hi @fateme,

are all your string in same format like “Thu Feb 06 18:19:17 +0000 2020”. If so it is easy to extract “Feb 06 2020” from it using String Manipulation node, then use String to Date&Time followed by Extract Date&Time Fields node to get week number.

Br,
Ivan

1 Like
9

Hi @fateme,

attached is the workflow that will provide the desired output.

The format of the string column should be same.

workflow_fateme.knwf (37.1 KB)

Regards,
Pavan

2 Likes
10

Hi
Thank you so much. :relaxed: :pray:

1 Like
11

Glad it helped.

BR,
Pavan

12

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.