Questions on transposing tables

[dgudkov]

@eyasu

May I please ask one more question. In the transformation section, there is a possibility of "trim table" from bottom or from top to show certain rows (say out of 30 rows show only 5 rows from bottom or top) which is quite interesting. Is there a possibility to show certain columns to trim from far left or far right (say out of 30 columns show only 5 columns from far left or from far right). If so, I can reduce my transformation by 40% because I can avoid transposing.

I assume column names are not fixed, because otherwise you could use "Select columns" or "Remove columns" transformation. If column names are not fixed, but the number of columns is fixed then you use the following workaround:

1. Save the dataset into a temporary file.
2. Load the dataset from the temporary files with ticked checkbox "Columns don't have headers". In this mode the headers become 1st row, and columns are labeled as Column1, Column2, Column3, etc.
3. Use "Select columns" or "Remove columns" to remove particular columns
4. Use "Label columns" transformation to use the headers from 1st row as the column labels.

It would be convenient to make steps 2-4) as a separate project that can be called from the main project using "Call project" transformation.

If number of columns is not fixed, then I don't think there is a way to remove N rightmost or leftmost columns. Probably that would be a candidate for Feature requests.