a column with custom values

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?

2 Likes

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:

Screenshot 2024-01-31 102936

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.