 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Load multidimensional CSV File | Login/Join |
| Platinum Member |
Hello, i have to load a csv file from SAP (tab seperated) into WebFOCUS. The problem is that the structure is not a typical flat file structure. (Content by Columns) I will get the data in rows. In the first row are header informations, like user_id, e_mail, company, date, in the sond row are deaper informations on the contracts belonging to the company like order or contracts, currencies, materials. In the third to n rows are the actual orders with amounts, companys, savings. Each row has the contract_id as key field to connect the rows. I also know in which table (SQL-Server) i have to write the specific values. Has anybody an idea how such a load process shoud work?? Regards Christian WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT | ||
|
| Virtuoso |
WF is very good at working with multi-record sequential files. Unfortunately, this does not apply to CSV format. What a work mate of mine did very recently was create a master with one field that was as long as the longest potential record and treated the CSV as a true flat file. He then ran one query for each record type and saved the output in their own tables (using a series of where statements to identify the different record types). He then created one master for each record type to read only those records as CSVs. This will only work if there is something in each record that can point to the parent record. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Virtuoso |
Could you post an example of the file contents? Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Platinum Member |
Hi Danny, do you mean the description of the CSV File, or a real example of the content of the CSV File?? Thanks a lot Christian WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT | |||
|
| Platinum Member |
Hi dhagen, thanks a lot for your help. Can you give me an example. I think this is more than beginner stuff!!!! Regards Christian WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |