Jump to content

Mike Harris

Members
  • Posts

    15
  • Joined

  • Last visited

Posts posted by Mike Harris

  1. 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. 

    image.thumb.png.3faaad68074b82592d376cd663f20333.png


    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). 
     

    image.png.0ace1452958c83f347ef1eb8f683011c.png

    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!

  2. 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?

  3. 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!

  4. 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!

  5. 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?

    spacer.png

  6. 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

  7. 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. 
    image.thumb.png.5a06dd9691010562637ad80b5c3815c2.png

    Well, that's it sir,
    cheers

    • Like 1
    • Thanks 1
  8. 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.

    image.png

×
×
  • Create New...