DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
ScottDun
Participant



Joined: 10 Dec 2015
Posts: 61

Points: 703

Post Posted: Fri May 17, 2019 1:22 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,

I have an excel sheet (2 tabs, different column names) that I want to simply push to an Amazon S3 bucket.

Basically, unstructured data stage --> Amazon S3

My problem, potentially overseeing what I need, is that I want both tabs to be output and I cannot figure how to bring them in.

Quickly on Excel:
Tab 1: A-D, 1-8 (4 column names)
Tab 2: A-F, 1-4800 (6 column names, 4800 can be increased however so not static)

In the config, I am lost on how to import both tabs. I import tab 1, rename the columns, then go to import tab 2 and it simply overwrites the columns. Any help would be great!

Thanks!

_________________
SCOTTDun
mouthou
Participant



Joined: 04 Jul 2004
Posts: 208

Points: 1991

Post Posted: Sun May 19, 2019 4:09 pm Reply with quote    Back to top    

Just a rhetorical thought for a worst case scenario considering the columns of one tab is overwritten by other tab.

Is there a way to separate those 2 tabs and process them separately and then send them to S3?
Rate this response:  
Not yet rated
ScottDun
Participant



Joined: 10 Dec 2015
Posts: 61

Points: 703

Post Posted: Sun May 19, 2019 6:03 pm Reply with quote    Back to top    

Requirements from customer are to have the two tabs in same excel sheet. I tried a job doing a funnel but it won't work on the exporting columns

_________________
SCOTTDun
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Sun May 19, 2019 7:12 pm Reply with quote    Back to top    

In case you'd not seen it yet and on the off chance it helps, here is the documentation for writing out Excel spreadsheets.

_________________
-craig

The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
Rate this response:  
Not yet rated
ScottDun
Participant



Joined: 10 Dec 2015
Posts: 61

Points: 703

Post Posted: Sun May 19, 2019 9:08 pm Reply with quote    Back to top    

I saw that, however, I didn't see where it says importing with multiple tabs. The documentation that I saw doesn't show, as well. The filepath is Link_Excel_EXTR, I go to the Link dropdown and it only shows that link, not multiple links [the documentation says Department and Employees somehow]. Whenever I LOAD the data, from Read Options, the import pane does show two dropdowns for the template data range but will not allow both to import due to the "Microsoft Excel Column" being similar, I am assuming.

_________________
SCOTTDun
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Mon May 20, 2019 2:13 am Reply with quote    Back to top    

Okay. I included the link after I saw this statement there:

Each input link of the Unstructured Data stage is associated with a separate Microsoft Excel sheet

Sheets = tabs.

_________________
-craig

The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours