Search the Community
Showing results for tags 'duplicate'.
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.
I am having trouble when duplicating a worksheet within the same workbench. If I edit the formulas with a new signal for it to refer to to do the exact same analysis I previously did, but with a different tag, it automatically updates my original worksheet within the workbench to the new tag as well. What I am trying to do is run the same analysis to different tags in separate worksheets in the same workbench. P.S. if I duplicate the entire Seeq Workbench and update the tag in the duplicate then the tags in my original Worksheet in the original Workbench stay intact. However, this just creates too many workbenches to keep track of, when what I'd like to do is have all worksheets within one workbench by being able to duplicate the worksheets and update the tags. Thanks for any help.
We noticed today that if you duplicate a worksheet within a book, you cannot change the tags without affecting the 1st worksheet. Is there a way to separate the worksheets so we can have the same calculations but for a different base dataset? We are trying to make this report for all of our production lines.