Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Source as a column when using Cat

    Posted 05-10-2018 07:33

    Hello,

    I recall that there is a way that, when you concatenate multiple nodes, you can add a column identifying the source of each record. So, in my example... I imported 3 Excel files and now, I'd like to concatenate them but not lose the file name because the source is important. How do I do that?

    Thanks,

    Rodi



  • 2.  RE: Source as a column when using Cat

    Employee
    Posted 05-10-2018 08:28

    Hi Rodi,

    You need to configure the Excel File nodes to output the file name. This can be achieved by including  the generatedFields directive in the WorkBookSpec property of the nodes.

    For instance, assuming the defaults are used for all other directives (i.e. you have not populated anything in the current WorkBookSpec properties - meaning the data from the first sheet will be read starting at cell A1), you can insert the following in the WorkBookSpec properties:

    <workbook>
     <generatedFields>
      <field type="filename" />
     </generatedFields>
    </workbook>

     

    If you have already populated the property, add the generatedFields directive to it.

     

    Regards,

    Adrian