LAE

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

Discussions

Members

Resources

Events

 View Only

  • 1.  Multi Excel import and addition of new column

    Employee
    Posted 06-15-2016 20:49

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

    Originally posted by: Sam.D

    Hi,

    I am required to import and merge a large amount of excel files (80+). At the moment I have this working fine by using a "Directory List" node feeding into an input pin of the "Excel" node. This works fine.
    Now what I want to do is create a new field on the import to store which file the data came from. Essentially I want to pass the "FieldName" parameter into a new column in the output data.
    Any ideas how this can be achieved?

    BRE V 5.1.0.0 Build 535

    Thanks in advance,

    Sam.D


  • 2.  RE: Multi Excel import and addition of new column

    Employee
    Posted 06-15-2016 20:55

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

    Originally posted by: Sam.D

    Ahha.....I got it.

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

    Nice and easy.