Data360 Analyze

I am looking to "flatten" several rows into a single row preserving values in different fields.  The values will never clash (in the example below a single account would never have a colour Red in one row and Blue in another row with a need to figure out which to preserve). 

My data looks like this:

Account,Colour,Number,Date
A,Red,,
A,,7,
A,,,12/11/72
B,Blue,,
B,,8,
C,Green,,

And the output I am looking for is:

Account,Colour,Number,Date

A,Red, 7,12/11/72

B,Blue,8,

C,Green,,

Ideas?

something like this? But adapting the script in the aggregate node to exclude nulls?

I am looking to "flatten" several rows into a single row preserving values in different fields.  The values will never clash (in the example below a single account would never have a colour Red in one row and Blue in another row with a need to figure out which to preserve). 

My data looks like this:

Account,Colour,Number,Date
A,Red,,
A,,7,
A,,,12/11/72
B,Blue,,
B,,8,
C,Green,,

And the output I am looking for is:

Account,Colour,Number,Date

A,Red, 7,12/11/72

B,Blue,8,

C,Green,,

Ideas?

I am looking to "flatten" several rows into a single row preserving values in different fields.  The values will never clash (in the example below a single account would never have a colour Red in one row and Blue in another row with a need to figure out which to preserve). 

My data looks like this:

Account,Colour,Number,Date
A,Red,,
A,,7,
A,,,12/11/72
B,Blue,,
B,,8,
C,Green,,

And the output I am looking for is:

Account,Colour,Number,Date

A,Red, 7,12/11/72

B,Blue,8,

C,Green,,

Ideas?

I am looking to "flatten" several rows into a single row preserving values in different fields.  The values will never clash (in the example below a single account would never have a colour Red in one row and Blue in another row with a need to figure out which to preserve). 

My data looks like this:

Account,Colour,Number,Date
A,Red,,
A,,7,
A,,,12/11/72
B,Blue,,
B,,8,
C,Green,,

And the output I am looking for is:

Account,Colour,Number,Date

A,Red, 7,12/11/72

B,Blue,8,

C,Green,,

Ideas?

I am looking to "flatten" several rows into a single row preserving values in different fields.  The values will never clash (in the example below a single account would never have a colour Red in one row and Blue in another row with a need to figure out which to preserve). 

My data looks like this:

Account,Colour,Number,Date
A,Red,,
A,,7,
A,,,12/11/72
B,Blue,,
B,,8,
C,Green,,

And the output I am looking for is:

Account,Colour,Number,Date

A,Red, 7,12/11/72

B,Blue,8,

C,Green,,

Ideas?