I have a requirement where I need to read data from csv file (e.g. file_one.csv), apply some transformations on the data and then load that data into a new csv file (e.g. file_two.csv).
I tried using Unstructured Data stage as my Target but it shows me an error that "it doesn't support input links". Is it possible to achieve above requirement using Unstructured Data stage (version 9.1)?
My bad.. So to clear out confusion and to explain better - I have excel spreadsheets which are saved as .csv file format. These spreadsheets have multiple client specific tabs in it.
So now, I want to process these spreadsheets data, transform them and create a new excel spreadsheet with similar client specific details in separate tabs.
Its not supported Writing to the spreadsheets using the unstructured Data Stage in 9.1 version, You can always do that in 11.5 version, Where you have ability to write to a single or all the sheets in a workbook.
So, any other method to achieve this?
The basic thing that I am looking after is generating new excel spreadsheet. I can manage with basic one single tab also.
Without access to the latest version, the typical answer for a "basic one single tab" would be simply another csv file. Excel will automatically open them as a spreadsheet, it would be up to the user to save it back as an xls.
You may be able to leverage ODBC for this, there are UNIX drivers specifically for Excel from what I recall. You would have to purchase them, however.
-craig
"You can never have too many knives" -- Logan Nine Fingers