DSXchange

Hi All,

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)?

Appreciate anyones help on the above query.

Thanks!

There's nothing "unstructured" about your data so why use that stage? Use the normal Sequential File stage.

csv files are simple text files that happen to have commas between data blobs that represent 'columns'. Nothing more.

You can process them just fine with a flat file & transformer stage.

Craig,

I have multiple tabs in the csv file which needs to be processed which I suppose makes it "Unstructured"

Thanks!

There are no tabs in a CSV file. It is a regular text file. Can you please be more specific?

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.

Any help would be much appreciated!

Thanks!

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.

Thanks Craig!
Just one more concern, does metadata in different tabs present in excel sheet needs to same in Unstructured Data Stage?

Thanks in advance.

Not that I am aware of, each is treated as a separate 'table' in essence from what I recall.

It seems like the metadata needs to be same. Otherwise it throws an error - Different number of columns in the sheets <sheet_name>.

That seems oddly... restrictive... to me.

Let's see what others have to say.

No inputs from anyone?

Thanks!

Open a support case.