I have a flat file given below:
Order573*20*376f972*Ntwk Adpt*29.99*Company A
UniqueOrder675*40*Wireless Card*801 Cassatt Road*Berwyn*PA*19312*Call Tech Support Immediately*97G45E*sku4513
UniqueOrder676*25*Wireless Card*Address Unknown*NA*NA*NA*Call Tech Support Immediately*97G45E*sku4513
BA * * *
Order573*20*376f972*Ntwk Adpt*29.99*Company C
I have two records in the flatfile profile, where Detect This File Format By is set as "specified unique values". And the first element of both the records is set to some identity value.
The second last record(BA ***) is a junk/unexpected record. Is there a way I can find out the junk record and throw an error saying the unexpected record entry.