Thread column values
Summary
Threads the contents of a column from all lines to one line.
Example: Determine shift sequences or shift schedules for one or several persons.
Example: Determine the shift sequence in a schedule.
Situation | The following data have been imported with Import text or CSV file 3.0
|
|---|---|
Settings |
|
Result |
Please note: This column can now be interpreted by Analyze text pattern (e.g., to find if there are 4 consecutive night shifts) |
Project-File | ... |
Want to learn more?
Settings
Threads the contents of a column from all lines to one line.
Columns of input table
Parameter
Examples
Example 2: Determine shift sequence for two persons
Situation | Data have been imported with Import text or CSV file 3.0, containing an identifier and shift type information:
|
Settings |
To determine shift sequence for each person, select A as identifier column. The resulting sequence should not be separated by any delimiters. It is necessary to sort the date from - date to columns (B and C). |
Result |
|
Troubleshooting
nothing known yet
Related topics
- A typical next operation is Analyze text pattern (e.g., to find out if there are 4 consecutive night shifts)