insert "X" at the end of an excel table

[Markus3003]

Hi all,

please check my screenshot:

I have some columns with some values (A-D); column E “Referenz” is empty and I would like to insert an X in the last row.

Has anyone an idea how to do that?

Thank you and BR
Markus

[dash_brookhart]

Hi @Markus3003,

Have you tried the Missing Value Node? You can configure it so that it fills in missing values with a fixed value, in this case “X”.

Regards,
Dashiell

[Markus3003]

Hi @dash_brookhart

thank you for your answer!

But how can I put the “X” only in the last row in column E in this case “E9”.

BR
Markus

[aworker]

Hi @Markus3003

This should do the trick based on a -String Manipulation- node:

substr( "Z", $$ROWCOUNT$$ - $$ROWINDEX$$ -1)

Hope it helps.

Best

Ael