LAE

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

Originally posted by: dmadigan

Hi,
I'm upgrading some graphs from 4.1.5 to 4.5.2 and have a question
regarding rotating data.

My 4.1.5 graph has the following input data:
customfield---fieldtype---value
custid --------int--------123
customer-----string-----customerA
startDate-----date------2011/01/01

Using a rotate node I flip it to:
custid (int) - customer (string) - startDate(date)
123----------customerA---------2011/01/01

I preserve the data type (string, int, date) by setting the TypeField to be 'fieldtype'.

I'm trying to replicate this with 'Pivot-Data to Names' in 4.5.2 and am having
problems preserving the data type (its setting all my columns to type String).

Is this something that is still supported in 4.5.2?

regards
Damien

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

Originally posted by: Tim Meagher

Hi,

That isn't supported in the Pivot - Data To Names node at the moment.
The node will use the type of the "DataField" and preserve this type.
For instance, if the field used as the "DataField" was of type "int" then all of the values would remain as ints in the output.

Since in this case, the DataField would be the "value" field, and this is a String, all will be output as String.

I will raise an enhancement request to see if we can add an optional TypeField parameter to the Pivot - Data To Names node such that there is no functionality missing that existed in the Rotate node.

Tim.

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

Originally posted by: dmadigan

thanks for your reply Tim.