Help Needed: Cognos Powerhouse. Accessing Flat File in Power House

[Jeff Hoffman]

Hi

Just add an extra field (1 char) to the end of your subfile definition to 
cater for the carriage return

Jeff

At 06:12 AM 8/11/2006, you wrote:
>The issue is that powerhouse does its own deblocking of data.
>If you remove the carriage returns from the file you will be ok
>You just need to ensure that the file length is correct.
>Regards,
>Ulrich Karthaus
>
>-----Original Message-----
>From: powerh-l-bounces+ulrich.karthaus=cgi.com at lists.sowder.com
>[mailto:powerh-l-bounces+ulrich.karthaus=cgi.com at lists.sowder.com] On
>Behalf Of vamsi krishna
>Sent: Tuesday, November 07, 2006 2:04 PM
>To: powerh-l at lists.sowder.com
>Subject: Help Needed: Cognos Powerhouse. Accessing Flat File in Power
>House
>
>Hi ,
>I need your help in Powerhouse. Actually i am very new to this
>technology.
>I work on a Unix system on which Cognos Powerhouse is installed.
>I have a text file( flat file) which contains a list of records with
>single
>item(call SRC). I need to access this data, and for that i need to put
>this
>data in a subfile and access through Powerhouse. I created a empty
>subfile
>with required structure and replaced the subfile with the text file
>mv VENDORS.txt DUNS_EXTRACT.sf
>
>  and tried to access it using quiz, and results were ambiguous(one
>record
>was split in two lines).
>For eg if the record SRC was EA3F446
>while doing i got the results in two lines:
>EA3
>F446
>Which is
>please tell me how to convert this txt file to a subfile.
>
>I'd be really grateful to you if you can help me in this
>
>Thanks and Regards,
>Vamsi
>--
>"Nothing is impossible as impossible itself says i m possible"
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>list archive at Google.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
>list archive at Google.