Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Inserting into tables from report but it's only inserting one row
Migrateduser
<p>I am working on a report that reads by line from a text file and parses it for data, and uses that data to insert a new row into a table. the parsing/query set up takes place in a while loop. The hope is that I would set up a correct SQL query using the data from the file, and then run the sql query using maximoDataSet.setQuery().</p><p> </p><p>I tried doing this in the maximoDataSet open script, but it only inserts the last line of the file I am working with. I tried moving it to the fetch statement, but it doesn't insert anything from there. I also considered inserting the data as a flat file source, but I couldn't figure out how to access each row of the data from the onFetch script. </p><p> </p><p>Any thoughts or suggestions? </p><p> </p><p>Thanks!</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet