Search the Community
Showing results for tags 'csv import'.
FAQ: I have a CSV file that has the start and end times of some historical events and various information about the events that I would like to use in my analysis in Seeq. How do I go about getting these events and all of their associated information into Seeq? Solution: Use the Import from CSV tool and Seeq Formula to bring in a condition comprised of each of these events and assign the data in each column of the CSV as a property of the condition. 1. Ensure your CSV file is formatted correctly for import into Seeq. The first column should be the event start time, the second column should be the event end time, and all other data columns should be to the right of these. A list of acceptable timestamp formats can be found on the Seeq Knowledge Base in this article. 2. Use the Import CSV File tool to bring the condition into Seeq. Drag and drop your CSV file or navigate to your file through Windows (Mac) Explorer. Under "Import File as" select "condition". Choose the start-time and end-time columns in the "Choose columns" section. Specify a max capsule duration that is just longer than your longest event. 3. Once your condition is imported, use Seeq Formula to assign the data from the other columns of our CSV as properties of each capsule. Begin by using the item properties for the CSV imported condition to duplicate the condition to Formula. Once in Formula, add the column headers from your CSV to the query in line 1 of the code, separated by commas. Then use the setProperty() function to assign each of the columns of the CSV as a property of each capsule. Once executed, the output is a new condition that looks exactly like the original from trend view in the display pane. However, this new condition has properties, that can be added to the capsules pane using the gridded+ button.
Hi All, I'm tying to upload a time series data which is like huge number of observation (around 600K observations) through CSV option. While uploading a file i'm getting an error as below. Could anyone please help me to resolve this problem. Note :- I have also convert the timestamp to seek compatible time stamp (yyyy-mm-ddThh:mm:ss) Regards, Jitesh Vachheta
Hi All, I've uploaded one sample file wherein i have 11 columns with Timestamp.Now in order to import all the 10 columns. I have to reiterate the entire activity 10 times to upload all the column into SEEQ. Do any one know how do we import all the columns in one go in Import CSV Function. Note :- Few Columns have difference in unit of measurement.will there be any issue if we ignore this. Regards, Jitesh Vachheta