Support Questions

Find answers, ask questions, and share your expertise

How to name the out flow file of QueryDatabaseTableRecord

Rising Star

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. 


@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).