Appending a string

[zielinska_km]

Hello,

I need to append a string based on a rule. I want all of my strings to be 5 characters.

Input:

string number
aaa 3
hhh 3
abhag 5
aq 2
p 1

Output:
string
00aaa
00hhh
abhag
000aq
0000p

Is this possible?

Thanks in advance

[mlauber71]

@zielinska_km the function should be padLeft in the Column Expressions – KNIME Hub

padLeft(column("column1"),5 ,"0" )

[zielinska_km]

I get error message: Compilation of script failed: Cannot invoke “javax.script.ScriptEngine.eval(String)” because “engine” is null
What should I do?

[mlauber71]

@zielinska_km check if you have installed the extension and maybe provide a sampel workflow that shows what you are doing. Also make sure you have the latest KNIME version.

KNIME Expressions

[HansS]

Hi @zielinska_km

You can use the String Manipulation node.

gr. Hans

[zielinska_km]

I have installed the extension, but I still get the same warning.

[rittiner]

Hello together

I have the same error. @zielinska_km were you able to solve the problem in the meantime?

Or does anyone else have any ideas?

Thanks for the help.

[ipazin]

Hello @rittiner,

and welcome to KNIME Community!

@rittiner

Or does anyone else have any ideas?

We can only guess. If you share workflow example I’m sure someone will take a look at it and help you. Simply put some data into Table Creator node and follow it with node that gives you above mentioned error. This topic might help you:

Reproducible (Minimal) Workflow Example

Hi there KNIMErs! What is this topic about? This topic is about helping yourself and KNIME community! How? By creating and sharing workflow examples that help and can be successfully ran by others When? When logic requires it. For example when you are opening a topic in order to get help (you are getting error or can’t configure node and would like someone else to take a look what is wrong; or you started a workflow and got stuck so need help with next step), when you are reporting …

Br,
Ivan

[rittiner]

It does not matter what function I use in the expression editor.

[ArjenEX]

I saw this passing by recently (which resolves around the same error)

Error in Column Expression Node

Hi Can someone please help with the error attached when I use the column expression node. Do I need to install something around Java? [image] Thanks, Akash.

If the steps mentioned in that topic do not resolve the issue, I would say @ScottF or another teammember has to jump in again.

And they will be asking for log files

[ScottF]

@rittiner and @zielinska_km -

Sorry for the trouble here, I will file a ticket (EDIT: filed, AP-19544) and ask our developers to look into this strange behavior with the Expressions nodes. In the meantime, is it possible that a fresh installation of KNIME AP will resolve the issue? I have a suspicion that this maybe due to a corrupted update from a previous version of KNIME - but this is only a suspicion and I may be wrong.

Can I also ask each of you to confirm which version of KNIME AP and operating system you are using?

[rittiner]

@ScottF thank you for the quick reply. In my case, the fresh installation of the new version did solve the problem. Thank you for your help.