Data360 Analyze

 View Only

  • 1.  getting filename when using Directort List Node with XLS files

    Posted 11-18-2019 07:08

    Hello,

     

    in this video we can see that the filename is added in an extra column after the data import:

    https://support.infogix.com/hc/en-us/articles/360020041033-Using-the-Directory-List-Node

     

    It works perfectly with a Directory List + CSV nodes

    But it does not wotk with Directory List + Excel nodes

     

    Any idea?

     

    Thanks



  • 2.  RE: getting filename when using Directort List Node with XLS files

    Employee
    Posted 11-18-2019 09:59

    Your WorkbookSpec property must include a 'generatedFields' stanza for the node to output the source filename with the data:

     

    See the 'WorkbookSpecExample' property's value within the node itself and the Input Connectors > Excel File topic of integrated Help documentation. The documentation for the latest version of the product is also available online here.

     



  • 3.  RE: getting filename when using Directort List Node with XLS files

    Posted 11-18-2019 10:33

    Great. Works perfectly.

    Thanks Adrian :)