Support Questions
Find answers, ask questions, and share your expertise

How to name the out flow file of QueryDatabaseTableRecord

How to name the out flow file of QueryDatabaseTableRecord

Contributor

I have a configuration where the QueryDatabaseTableRecord queries the table from mysql, i have used RecordWriter as CSVRecordSetWriter and used CSV Format as Tab-Delimited.

 

I want to store this flowfile as table-name with the extension xlsx, any help really appreciated. 

1 REPLY 1
Highlighted

Re: How to name the out flow file of QueryDatabaseTableRecord

@murali2425   After you get the data from QueryDatabaseTableRecord next use updateAttribute and set filename attribute accordingly. I think (${table-name}.xls) assuming you have the attribute table-name.   Next you would store the contents of flowfile (putFile, PutHDFS, S3 Bucket, etc).