Question: Impossible to get the right columns from a CSV file when using type="data_colum"
0
avillahoz • 10 wrote:
Hi,
I have the following source code for a better understanding of an issue during a tool development of mine:
<inputs>
<param name="galaxy_csv_file"
type="data"
format="tabular"
label="Encoded Data" />
<param name="galaxy_location_vector_column"
type="data_column"
data_ref="galaxy_csv_file"
numerical="False"
use_header_names="true"
label="Column Containing Location"
help="" />
I got the column headers pre-loaded to be chosen from the user, all fine until now.
As my team is using the CSV format to interchange data, I changed into
<inputs>
<param name="galaxy_csv_file"
type="data"
format="csv"
label="Encoded Data" />
<param name="galaxy_location_vector_column"
type="data_column"
data_ref="galaxy_csv_file"
numerical="False"
use_header_names="true"
label="Column Containing Location"
help="" />
It still captures all the row data as an entire column, not all the columns separated by commas, despite using standard CSV files and explicitly choosing the CSV format before uploading the CSV data. Even following the CSV dialect by default as csv.excel when saving as a .CSV file from Excel.
Any idea about why type="data_column" does not react to the CSV data?
Thanks,
Angel Villahoz-Baleta.
ADD COMMENT
• link
•
modified 6 months ago
by
Jennifer Hillman Jackson ♦ 25k
•
written
6 months ago by
avillahoz • 10