Dear Team
iam new on the board and i cant switch totally my head fully to Knime yet
iam looking for an elegant solution but i cant see it already
In excel is easy : if ULID -1=ULID then ITEMCLS= “KELL” or do ITMCLS= “KELL” while ULID-1=ULID.
I solved it with nodes but i believe in one step can perform it
Ordered by ULID and TALALT columns and if the TALALT has any value (“XTALALT”) then ITMCLS = true while ULID-1 = ULID
I would like to see same value in ITMCLS where ULID-s are same and the first TALALT value is “XTALALT”
The picture shows the expexted result.
Can anyone provide other solution ?
Hi @Treesimon
I think the “Column Expressions” node can be useful for this case. This node allows you to create Excel-style “IF” conditionals (only the syntax is javascript). For example:
Link to node documentation: https://kni.me/n/2_0ji_xeG-SudFu-
Best
1 Like
Indeed you are true
But unfortunately that mentioned node cant fill cells when the condition cells are empty ( to that place i like to insert “do while” )
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.