add suffix month

[MoLa_Data]

Hey friends;
I have a column with the months (“jan”, “feb”, etc) but I need replace or suffix to full name month (“January”, February", etc) How can I do it?
Thanks in advance!!

[mlauber71]

@MoLa_Data you could adapt one of these examples and maybe use a rule engine

Remove part of a column name and insert new column headers – mlauber71

Modify column names using Java Edit Variable – takbb

[takbb]

Hi @MoLa_Data, the workflow examples supplied by @mlauber71 should be adaptable to your needs (and I am flattered to have @mlauber showcase one of my workflows alongside his own! )

I have also uploaded an alternative for your specific requirement, which uses some similar techniques to those in the other flows.

Rename Columns from Lookup Table.knwf (16.5 KB)

[Thyme]

In case you’re after replacing the values in a column, not the column names:

A Rule Engine does the trick. Keep in mind that it’s case sensitive.

extend_short_month.knwf (16.4 KB)

[MoLa_Data]

Excuse me if I have not explained it well, but I wanted to replace the values in a colum, not the column names.

Thank you all for helping me

[rolandnemeth]

Hi @MoLa_Data,

Please find attached a workflow with two approaches, with Rule Engine and Joiner nodes.

Best Regards,
Roland
replace_short_month_names.knar.knwf (27.0 KB)