Data360 Analyze

Hey all,

I've gotta be missing something very easy, so hoping someone can share some wisdom. I'm using a Transform node to go through a list of tickets. Each ticket can have anywhere from 5 to 20 rows with various datapoints, and one of those is Department. 

Edited for simplicity

End of day, I'm trying to understand whether a TICKET_NUMBER has ever been assigned to a Department. If there is a better idea, let me know, but for now I thought I'd use a simple list. At Row 1, check my empty groupList [ ] and if Department isn't already inside, append it into the list then I'll perform some unique calculations based on it having not already been part of the List. 

------------------------------
Daniel Pisani
Knowledge Community Shared Account
------------------------------

Hi, for me it would be a lot easier to understand. If you send pictures of a sample data input, and expected output.

Like below:

What you are describing that you are doing is similar to what I've done very often lately.  So I am pretty sure that the problem you are dealing with is a typo or mistake.

Here is a simple way to do what I understand you are asking for using an Agg node:

Input:

Agg:

Note that the second parameter of the joinStrings() function indicates whether or not to include Nulls in the result.

outputs[0]["DPTs"] = group.joinStrings(fields["DPT"],False," | ")

Output:

------------------------------
Ernest Jones
Precisely Software Inc.
PEARL RIVER NY
------------------------------