Partek Flow Documentation

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you have a text file that contains sample information, attributes, and IDs and attributes as well as the filenames of your data, you can create the sample table and start the data import at the same time. This is particularly useful for projects where multiple files are associated with the same sample (e.g., a sample ran in multiple lanes in the sequencer).  For this type of import, the text file must be located in the Partek Flow server (Figure 2).

Each In the text file, each filename to be associated with the sample must be separated by a tab.  That means, if you are using a spreadsheet software to generate the text file, there is a maximum of one file per column.  You also need to add headers such as file1, file2, etc... , to define the text filecolumns. There is no limit on the number of columns on the text file. 

The filenames on the table must show the proper extension extensions of data types compatible with Partek Flow (see Types of Data).

The actual files can be in the same directory as the text file or in a different directory. However, if If the files are in a different directory, you must specify include the file paths. 

Text file and data are in the same directory

If the text files are in the same directory

...

as the Data files, simply include the filenames in the text file as shown in Figure 6. You do not have to specify the file path.

Image Added

Figure 6: Text with Attributes and Filenames

The text file will be summarized as in Figure 5. The first two columns show the headers and example terms parsed from the text file in Figure 3. The suggested attribute names can be renamed before import. Columns that contain unique entries are recognized as possible Sample IDs and can be selected using the radio button. You can choose which attributes to be included and, if applicable, whether they are numeric or categorical. The Show/hide file preview link allows you to preview the text of the tab delimited text file you are using.

In the example in Figure 4, the columns for "Sample name" and "Freezer Location" are both unique and the former is selected as the Sample ID. The "Freezer location" has been deselected and it will not be included in the resulting Sample table. Since "Age" has all number terms, the Attribute type column for it is a drop down menu to choose between Numeric and Categorical. There are no filenames in the text file so the Files column is empty.

A feature of creating the sample ability to combine this step with data import ... the additional feature of importing samples during table creation (described below) are currently only available if the text file is in the Partek Flow Server. 

 can only be at the same time as creating the sample table) can only be performed if

 a sample table that also includes the locations of filenames can only be based on the sample table (as described later in this section) 

The text file must be in the server or a folder that is readable by the partek flow server. the text file contains filenames

A valid text file:

TABLE TEXT FILE NO PATH

 useful if there are many files for one sample, You can add as many columns as you want on the right 

Flow recognizes sees that some columns in your text file are filenames of 

FIGURE OF NAVIGATION... SHOW THAT THE DATA IS IN THE SAME DIRECTORY MYDATA
FIGURE WITH FILENAMES
FIGURE RESULTING TABLE
FIGURE IMPORT task
FIGURE EXPANDED TABLE

7. Filenames that are recognized as valid file types and also located in the same folder as the text file are presented in the Files column.

Image Added

Figure 7. Selecting the attributes, Sample ID and filenames

 

Click Import and the table will be created (Figure ). Click Show data files to expand the table and associate files. For more details see the Adding samples section.

 

 

 

Image Added

Figure 8. Sample Table created from a Text File and files are queued up for the import

 

Figure 9. Task Queue showed each file is queued for import

Figure 10. Sample Table created from a Text File with Attributes and associated imported Files

 

In the example above, the text file and Data files are in the same directory. If your samples are in different subdirectories, YOU CAN USE PATHS. RELATIVE OR ABSOLUTE

...