Data360 Analyze

 View Only

  • 1.  Count of product to Array or List

    Employee
    Posted 09-29-2020 21:33

    Hi All,

    I have a set of products and a count for each that i need to turn into a list that details how many of each product the customer has. I have 10 products, each row has a different combination of products and i dont want to list products that are 0. Im looking to understand the best way to achieve this. I've attached some dummy data and this needs to be expandable up to 22 different products.

    any help would be most appreciated!

     

    Thanks

     

    Attached files

    ListExample.xlsx

     



  • 2.  RE: Count of product to Array or List

    Employee
    Posted 09-30-2020 10:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    You can use a Transform Node to get the desired output. You create an output field that will contain what you want, then use a for loop and some logic to determine which values are greater than 0. Here's an example Data Flow that's using your Dummy Data.



  • 3.  RE: Count of product to Array or List

    Employee
    Posted 09-30-2020 18:55

    Thanks for taking the time, but am I missing something.. I dont see the flow?



  • 4.  RE: Count of product to Array or List

    Employee
    Posted 10-13-2020 03:41

    Here is Ryan's example data flow

     

    Attached files

    Counting EX - 12 Oct 2020.lna