Data360 Analyze

 View Only
  • 1.  Select Fields Custom Node

    Employee
    Posted 09-25-2017 04:38

    When building a data flow and analysing data a frequent requirement is to subset your data to include only certain fields.

    The attached 'Select Fields' node is an easy to use Community custom node that allows you to select the fields by entering a comma-separated list of the fields to be output. The field names can be entered manually into the 'FieldList' property or, if the previous node has been run, you can use the Input Fields functionality to insert the name from the property's context menu (though you will still need to insert the commas yourself).

     

    If you want to output all fields except certain fields you can specify the fields to be excluded in the 'ExcludeFields' property - again using a comma-separated list of field names.

    You cannot specify the 'FieldList' property and the 'ExcludeFields' property at the same time.

    After you have imported the .lna file you can find the node in the 'Aggregation and Transformation' category of the All Nodes library.

     



  • 2.  RE: Select Fields Custom Node

    Employee
    Posted 02-22-2019 07:24

    Infogix recommends that for new projects you should use the Modify Fields node that was released in Data3Sixty Analyze v.3.2.7.

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

    https://support.infogix.com/hc/en-us/articles/360018962734-Data3Sixty-Analyze-3-2-7-is-Now-Available 

    For further configuration details see the Help or view the online documentation for the latest version of the software here:

    https://d3sa-preview.infogixsaas.com/docs/dist/help/Default.htm#e-node-help/Aggregation_and_Transformation/modify-fields.html