I have an excel file that for example loads the values like this:
Data
3
4
5
6
7
I want to create a custom column, that is to say that I can place a data, depending on the row, for example
Data Limit
3 5
4 10.0
5 10.0
6 4
7 8.0
How can I do it?
Hi @Aprins
What should the logic be behind the Limit column? There does not seems to be any pattern in it. Or do you want the user to fill this in manually?
Hello @Aprins,
Yes, I agree with @ArjenEX because determining the limit value is crucial in setting up the conditions for the new column.
If you want to do it manually, you can use a Rule Engine node and write expressions like:
" $Data$ < 4 => 5
$Data$ = 4 => 10
$Data$ = 5 => 10
$Data$ = 6 => 4
$Data$ = 7 => 8 "
Output:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
