Hi All,
Guys, I need your help. I have script that will extract data from teradata using fast export. I will attach the script here. The reports were saved in csv format using vendor code. I need to rename the reports using the vendor name and add column names. When I ran my script, the filename were changed but the data is the same for all the reports. I also attached the reports generated from the script. Thanks in advance.
If I was the person employing you to do this I would be extremely upset if I discovered that you had posted real data on a public web site, complete with the "The contents of this website are proprietary and confidential to Safeway Inc." message. Are you sure you don't want to edit your post and provide sample data instead?
No offence intended if that is not the case, but it sure looks that way!
You need to include your new code inside the for vencode in ... do ... done loop, not outside it. Otherwise the $vencode variable will not change. You will also need to figure out a way to map the vendor names to the correct vendor codes.