cancel
Showing results for 
Search instead for 
Did you mean: 

Count the records in target table for each file

former_member241220
Participant
0 Kudos

Hi All,

I have 5 flat files as source with same stature, I want to load the data into single target table. My requirement is I want see each file count in my target.

Thanks

Murali

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Murali,

In the data flow click on the flat file which will open the properties, on the bottom will be the Source Information. Give Yes in Include File name column option.

After merging all the five source files you can use function gen_row_num_by_group(QT_Merge.DI_FILENAME), then take the max value against the filenames.


Regards,

Senthil

Answers (0)