Jump to content

Walter Rossi

Rulexer
  • Posts

    14
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by Walter Rossi

  1. Hi again Pushkar! Actually, your rule is not logically wrong, but if you don't put the label 'INVALID' the other cases are not managed (I mean 'Valid' and 'Not Applicable'). Anyway, I made a comprehension mistake, if your goal is to have 'Valid' when the "COLUMN B" is equal to 0 or 'MISS', then you have to write the rule like that: IF "COLUMN B" != 0 AND "COLUMN B" not is None [f] WHEN "COLUMN A" in {'1'} THEN 'INVALID' The reason why I use AND instead of OR, it because that's a pretty application of the De Morgan rule for the logical operator Let me know if now it works!
  2. Hi Pushkar! Firstly: is the COLUMN B a column with integer values? In that case I think that in the second rule after the OR should be: "COLUMN B" == 0 | "COLUMN B" is None [f] ; since as I remember to you, you are checking for the invalidity, so you have to put the contrary condition and if the column is an integer you cannot use the 'MISS' value to check the None (this is intended to be compiled like that only for the nominal column). In case it is a nominal column, it should be: "COLUMN B" in {'MISS','0'}. And I don't know if it was a typo, but in the second rule there are two "WHEN"!! Have a nice weekend!
  3. Hi Pushkar, what you write is correct: the syntax with [f] turns out to be necessary only if you decide to apply any formula. This can be a comparison, through mathematical and logical operators (so "==", ">", "<", "!=", and so on), or should we want to apply any formula that Rulex allows to handle (simple examples can be the formulae "sum", "mean", "max", "min", and others). Let me remind you that when using a formula, it is necessary to write the keyword [f] following the formula in question, separated by a space. The only cases in which you will not see [f] is when checking whether a column has a value that is part of a set, for which you then use the "in" operator (e.g., "Column A" in {'This value'}), in this case [f] is not required. I hope I have made myself clear! Please, let me know if you have any other curiosities. Thanks and have a nice day!
  4. Hi Pushkar, nice to meet you! Before I answer your question about how to write the rule correctly, I would point out two stylistic and conceptual details in the syntax to apply to any rule: IF and THEN is customary to always write them in uppercase, for better distinction between keywords and user-entered and therefore editable fields If you want to check whether a rule is valid or not, for the Rule Engine you should always write the rule in such a way that it is checked for invalidity, this way 'Valid', 'Invalid' and 'Not Applicable' cases are automatically handled. Also, output values should be written in single quotes and not double quotes, unless you want to save them in a column, in which case the column name goes in double quotes and the value in single quotes (so in this case it will be to write 'INVALID' and not "INVALID"). As for the rule on the other hand, given these premises, the correct form to write it is: IF ("Column A"%7) != 0 [f] THEN 'INVALID' Through the % operator in fact you can get the remainder of a division operation. I hope I have dispelled all your doubts, if not, feel free to ask me for more information! Have a nice day!
  5. Hi Jack! When creating a module from a selection of tasks, it is always necessary to pay attention to the sources. To create a module, you must define an input mapping to which you must link tasks within the module. If, as in your case, there is no defined/static input, it is possible for the program to return an error, especially if there is a direct thread before the module that connects to an import. It is good practice when creating a module to insert a Data Manager task before any input that will go into the module, that way the inputs that will end up in the module will always be defined and the tasks inside the module will always know which external tasks to point to. Here some screenshots to understand better! (The red rectangle means the selection to put inside the module) Wrong module creation: Adding Data Manager: Good module creation:
  6. Hi Mike! It is not necessary to enter the source every time. You can configure a source so that it is saved on Rulex Platform. To do this, move via the explorer to the location where you want to create the SharePoint source, uncheck the "Flow filter" flag at the top, click on the "+" icon, and then select "Add New Filesystem". Through the window that opens you can select the type of source you want to add, in the case of SharePoint click on the item of the same name. After clicking "Next" you need to enter the URL, username and password of the source you want to access. Having done this, click on "Next" and finally in the last section assign a name to the source you want to create. Once the source has been successfully created, you can select it in any task whenever you want. To do this, just select "Saved" in the source field, click on the three dots and move to the location where you created the source previously and select it. This way, you will be able to access the files that are in the source whenever you want.
×
×
  • Create New...