[What exactly is None]

Hello Griz! 

Thank you for your feedback on documentation, None not is None produces False, there is a typo in it.

The None value is meant to be an empty cell. 

The 'is' and the '==' operators have different functions in formulas:

• 'is' means equals to: this operator can be used with any attribute type, and it only returns a binary True/False value.
• == means equals in comparison: it is inserted automatically between the left and right side of the formula. When it is used with nominal attributes containing a None (empty) value, it returns a binary true or false as well

While if you are talking about the filtering options in the Data Manager's query panel, consider that the difference between ==, != and is, not is is meaningless if both the compared attributes are nominal or binary due to the None operator properties used in Rulex Platform.

I hope this helps! 

[Is there a way to check if a column exists and if it does include in a formula]

Hello Griz, 

thank you for opening this topic on our Community.

By specifying the $names parameter in the left-hand side member of the formula bar in the Data Manager task, you can bulk edit the dataset's attributes' headers.

You can find more information about this specific use case on the technical documentation at the following link: Computing Formulas in the Data Manager (rulex.ai).

If you need further clarification, don't hesitate to contact us!

Have a wonderful weekend.

[How to change the Resource Manager Working Database to MSSQL?]

Hello Llewelyn,

the corresponding documentation's page has now been updated. 

You can find it at the following link: Changing the source files main folder (rulex.ai)

Should you need further information don't hesitate to contact us!

Best,

Sara 

[Variable occurrence]

Hello Sophia,

In the top-right part of the stage, you can see the icon of a binocular. If you click on it, you access the “Search” function of the Rulex Platform. By searching “Sales”, you will have a list of all the times in which that column was used in your flow, and you will be able to see where it was used, in a single view. 

For more information check our technical documentation Searching Tasks

Have a wonderful day,
Sara

[How to change the Resource Manager Working Database to MSSQL?]

Hello Llewelyn,

bore da?

Thank you for opening this topic on the Community!

Unlike Rulex 4 Rulex Platform isn't based on a SQL working DB, so the operation you're trying to do doesn't exist. You can see the folder where everything is saved in the Settings Manager. I'm sorry to say that Rulex Platform documentation wasn't updated on this point - my bad.

We will contact you as soon as the documentation page has been published.

Have a wonderful day,

Sara 

[Apply and sum function difference]

Dragging an attribute onto the APPLY area in the query panel and choosing the function implies modifying the attribute itself replacing the original values with their output, which can only be a simple sum of the attribute dragged onto the Apply area. The query modifies the dataset’s structure. The APPLY query cannot be used to fill an empty attribute with the sum of another one’s values.

The function sum(), which can be typed in the formula bar, allows you also to group the results by a certain attribute’s values. You can use it to fill any attribute with any attribute’s sum, optionally grouped by another one’s values.

 

If you need more examples on how to use the apply panel and the sum function, follow the links to the technical documentation: Apply in the Query Panel and Sum function

[HTTP JSON Import task, adding a body?]

Hello Llewelyn,

here is the procedure to successfully add a body:

1. Create (externally) a json file which contains the body you want to add.

2. Import the file through an Import from Json File (json1) task.

3. Add an Export to Json File (jsonexport1) task, link it to the existing import task and open it to:

   1. Configure the required HTTP options.

   2. Add the required response file path.

4. Save and compute the task.

5. Add a second Import from Json File (json2) task to the flow and configure it so that it imports the json file you have exported previously.

6. Configure the above-mentioned (json2) task’s priority and set it at -9999, to really import what has been just exported. To know more about setting priorities on the Factory, refer to this page: Prioritizing Tasks in the Factory (rulex.ai)

I am attaching a screenshot with the expected flow.

Would you like to share with us more information about this issue?

Remember that everything posted on this community is PUBLIC, if you're about to share sensitive values please contact us via email at: community@rulex.ai

Best,

Sara