Mike Harris

Hey Nydia! You can use the “Check Dataset” task. You'll have to link both datasets to it. For specific checks, you can also consider using a “Full complement" Join, editing the options according to the check you want to make.

I've just inserted in a DM the number rows one for each week that I needed and after it I filled the column "Week" using the function enum()

Hi! This is a possible way to get what you need: 1. Create a table with the list of weeks: • You can start with an empty source and fill it using the enum() function. • Alternatively, you can start with the main table and group by week, assuming that all the necessary weeks are present at least once in the dataset. 2. Create a table listing the resources. This can be done by grouping by the resource in the main table. 3. Join the two tables above using a Cartesian product, as shown below. The result will be a table where you have all the possible combinations of week/resource (in the example below, the weeks range from 1 to 10, but this will depend on your specific use case). 4. Join the output of the above join with the main table using a left outer join. The output of this join should be the table you were expecting. Hope it helps!

Hi everyone! I was wondering if there is a way to run Rulex Platform via CMD? Thanks

Hi! I am using a process variable to perform a filter on a datamanager task. The filter is S12_Measure<=@hmax and I set hmax=100. It worked well the first time and it removed all the rows where S12_Measure was greater than 100. However, when I try to change the value of the process variable to 90 and recompute the datamanager, the result does not change. The dataset still contains values for S12_Measure between 90 and 100. Can anyone tell me what I'm doing wrong?

Hello! I have two tables containing different information about the same customers. In one table I have all the customers, while in the other I have only the customers who have used some premium services. I wanted to add the services information to the main table, without losing the customers who didn't use the premium services and I used a left-outer join. I expected the resulting table to have the same number of rows as the left table but in reality, there are more and I don't understand why. Thank you!

Hi all! The Join task changes the order of the rows of my dataset. Is it possible to keep the original order after the Join? Thank you!

Hi all! I have a workflow with several tasks and at the end an "Execute Rulex Flow File" doing a loop including a "Mixed Integer Linear Programming" task. If I run the whole process (Compute All) I get a result which is different from that obtained by computing the Execute Rulex Flow File alone. The input data for the Execute Rulex Flow File are identical in the two cases but the output table is different. Thanks for your help

Hi all! I need to count the number of nodes in a graph. Starting from a datamanager in the Parent, Son, Group format I cannot simply do the group on the "Parent" column because some nodes do not have outgoing edges( e.g. node 4). How can I do this?

Hi all! I have added a SharePoint source to a task, but I would like to add it to multiple tasks. Do I need to enter it each time?

Hello! How can I monitor the execution of a module when I compute it if I only see the "Execute Rulex Flow File" task and not the tasks inside the module? Thanks

Hello! I’ve got a dataset with 1050 attributes (all numerical) and in some values inside of these I have the “NaN” string, which means that I can’t turn them in to continuous attributes from nominal. Is there a quick way/task to change all “NaN” values in all attributes to blank values without applying a formula to each attribute? I tried the fill and clean task but I couldn’t figure out a way to use this one for this purpose. Thank you in advance

Hi @Jack Adams welcome! Don't worry, it's not rocket science Open an import task (such as Import from Text File) and select the Advanced section, here you will just have drag and drop all the files that you want to import. Well, that's it sir, cheers

Hi folks, I'm new on this community, I hope that you can help me with this error message that I received. Right now I'm not able to complete the computation of the join task.