getting filename when using Directort List Node with XLS files

Follow

Stéphane O

• November 18, 2019 14:40
• Edited

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

0

• 

  Adrian Williams

  • November 18, 2019 16: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.

   

  0

  Comment actions Permalink
• 

  Stéphane O

  • November 18, 2019 17:33

  Great. Works perfectly.

  Thanks Adrian :)

  0

  Comment actions Permalink

Please sign in to leave a comment.