How to Write Data in to Multiple Tabs in Excel File

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nveejas
Participant
Posts: 11
Joined: Sun Sep 26, 2010 11:42 pm
Location: illinois

How to Write Data in to Multiple Tabs in Excel File

Post by nveejas »

Source is the database. Target is a single excel sheet.
Have several queries, in that my first query result should be in excel sheet first tab and my second query result should be in excel sheet second tab and so on.

design looks likes as below :

database -- 1st query Trans---> seq.file (csv)
database-- 2nd query Trans---> seq.file (csv)
database-- 3rd query Trans---> seq.file (csv)

Here all the 3 results should be in a single excel sheet separated by tabs.

Can we implement this using sequential file? Is there any other stage supports this feature?
or else is this possible in unix so that will use the command in after job subroutine.
Thanks,
Sajeev N
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As far as I know, that may only possible using the Unstructured Data stage which is not available in your version. That's a job for a BI / Reporting tool, not ETL.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could use ODBC driver for Excel (if you can find one for UNIX) and write to the three tabs as three distinct system tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I thought about that but for some reason while knowing it could read from multiple worksheets / tabs, thought there were issues with writing to multiple worksheets. I guess we'll see! :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
nveejas
Participant
Posts: 11
Joined: Sun Sep 26, 2010 11:42 pm
Location: illinois

Post by nveejas »

Thanks for your inputs. Let me try if we can do with ODBC connector for Excel and provide my result.
Thanks,
Sajeev N
Post Reply