Trying to use this formula in knime but cant get it right
I done it in power bi
I don’t know much about PowerBI, but if you can translate to natural language what your logic is doing maybe I can help you with translating into Knime 
Trying to do a conditional formula to get the text of a column if in another column contains the text “PLANT CD”.
= Table.AddColumn(#“ExtractPlant Inserted Text Range”, “Custom”, each if Text.StartsWith([Column1], “PLANT CD”) then [Text Range] else null)
many options:
first
Rule engine with column LIKE “PLANT CD*” => Text Range
second
column expression supports if else
third
Expression node also supports if else
fourth
you can split the dataset using a row splitter and then manipulate all in the subset
…
1 Like
Should be possible with column expression legacy node:
If(contains(columntocheck,“PLANT CD“,) {
<-Column if true>
} else {
<-Whatever else>
}
Then use a row filter to remove rows with the Whatever else „flag“