Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Formating output of DM flow

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Formating output of DM flow
 Login/Join
 
jim99
Member
posted
Hi,

I would like to format the output of a DM flow.
The flow I am working on reads a relational table (Source) and then writes to a flat file (Target).

Specifically, I would like to change the following default behaviour.

1.I would like to use a '|' as a separator instead of a comma (in COMT).

2. In COMT target files, the text fields are wrapped in double quotes. I would like to either
wrap all fields in double quotes, or do not wrap any fields in double quotes.

3. Is there a way to insert a standard (header) row in a specific flow. I.e. I need a header record to say 'HEADER ROW' the target flat file.

The idea is to do as much as above in the GUI -

Any help would be appreciated,

I am using Data Migrator version 768 on Windows Server 2003.

Thank you

Jim
 
Posts: 5 | Registered: August 01, 2007Report This Post
LarryC
Member
posted Hide Post
Hello Jim,
You can accomplish 2 out of the 3 items you've requested when using a Delimited Flat file as your target within a DataMigrator Flow. From within your Flow, open the target's properties and you will find that you can:

1) To customize the delimiter. In my testing I
was able to specify various characters and
this worked just fine in the output file.

2) You can specify what the enclosure character
should be as well. You can leave it blank if
you do not wish to enclose the data in
anything.

3) This item can not be customized. While there
is a HEADER option, the documentation states
that the HEADER option will insert the
column nams as the heading on the first row
of data; the column names are surrounded by
the character specified in the Enclosure
field. This HEADER is not customizable.

Regards,
Larry Civelli
CSS
Information Builders Inc.


Larry Civelli
Information Builders
 
Posts: 3 | Location: Atlanta | Registered: March 26, 2003Report This Post
LarryC
Member
posted Hide Post
One item I forgot to mention, the above information can be found in the DataMigrator Users Guide. Chapter 5, in the section titled: Specifying Data Target Options. Within that section there is a reference section for Delimited Flat File Targets.

Regards,
Larry Civelli
CSS
Information Builders Inc


Larry Civelli
Information Builders
 
Posts: 3 | Location: Atlanta | Registered: March 26, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Formating output of DM flow

Copyright © 1996-2020 Information Builders