Data360 Analyze

Could we please get a node that allows for manual control of fields and data types using a visual UI rather than having to code it in the transform node.  

It's currently an effort to drop superfluous fields.  

I would see the node working as follows:

Show a list of every field on the input. 

Show three columns next to each field. 

The first column shows the current data type. 

The second column has a check box to include or exclude the field in the output.

The final column has a drop down menu to choose the desired data type

Hi Stewart,

We have an item on our roadmap to introduce a modify fields node which will provide the ability to select fields and change the data type of particular fields.

In the interim, you may be interested in a couple of custom community nodes that provide the ability to:

Select Fields

https://lavastorm.zendesk.com/hc/en-us/community/posts/115001265754-Select-Fields-Custom-Node

and

Rename Fields

https://lavastorm.zendesk.com/hc/en-us/community/posts/115001574994-Rename-Fields-Custom-Node

You may also be interested in the Working with Untidy Date Values article which includes a node to convert string representations of dates to Date type fields:

https://lavastorm.zendesk.com/hc/en-us/community/posts/115006926013-Working-With-Untidy-Date-Values

Regards,

Adrian

Just to close the loop on this request, the Modify Fields node was introduced in Data3Sixty Analyze v.3.2.7.

You can read an overview of its capabilities in the associated release announcement article:

https://lavastorm.zendesk.com/hc/en-us/articles/360017573094-Data3Sixty-Analyze-3-2-7-is-Now-Available

For further configuration details see the Help or view the online documentation here:

https://preview-desktop.lavastorm.com/#e-node-help/Aggregation_and_Transformation/modify-fields.html%3FTocPath%3DNode%2520help%7CAggregation%2520and%2520Transformation%7C_____8