question Re: Different files with different columns to be loaded in single Nifi flow in Support Questions

Different files with different columns to be loaded in single Nifi flow

Reshma — Wed, 02 Sep 2020 23:54:25 GMT

I have different input files for different sources. Can I create a common Nifi flow which processes all the different kind of files? Each files will be having different types of columns and different types of output table to be loaded. For example, File 1 will be having column A, Column B to be loaded to Table AB, File 2 will be having column C, Column D, Column E to be loaded to Table CDE. Can I achieve this in a single flow or should I create different flows for different types of files?

Re: Different files with different columns to be loaded in single Nifi flow

SagarKanani — Fri, 04 Sep 2020 07:33:53 GMT

Hi....you can create a single flow as long as you can distinguish the files for e.g using the filename. You can route on attribute and load it different table.

Hope this helps. If the comment helps you to find a solution or move forward, please accept it as a solution for other community members

Re: Different files with different columns to be loaded in single Nifi flow

Reshma — Fri, 11 Sep 2020 17:10:23 GMT

@SagarKanani Thanks for your reply.