Hi All,
We have a requirement to capture all the files in a folder which have same metadata. I am using the file pattern to read all the files using sequential file stage. How can we track the file that is causing problem or the file that cant be extracted from the set of files.
Thanks in advanse.
File Pattern
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
check this post and try setting those parameters,.
viewtopic.php?t=121263
viewtopic.php?t=121263
You can run an awk command to find list of files which dont match metadata
Replace comma by field delimiter and assign no_of_fields as per your input
Code: Select all
for file in *
do
awk -F"," -v no_of_fields=2 ' NF != no_of_fields { print FILENAME; exit } ' $file
done
You are the creator of your destiny - Swami Vivekananda
It lets you know which one of the (possibly many) files you are reading that any particular record is from.kogads wrote:I still cant understand how we can track the error file if we have the environment variable $APT_IMPORT_PATTERN_USES_FILESET set to true and File Name column is provides in sequential file?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers