How to provide column names manually in script for importing multiple text files?

Singhthisside — Mon, 26 Feb 2024 16:10:02 GMT

Hello,

I was able to use the import multiple files tool to get a Skelton script. I would like to add column names to created table through the script. Is there a way to do that?

Re: How to provide column names manually in script for importing multiple text files?

jthi — Mon, 26 Feb 2024 17:27:29 GMT

You could for example have a list of column names and then loop over that list while setting the names. Depending where you get the names how you might want to loop might be different

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(0),
	Compress File When Saved(1),
	New Column("Column 1", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("Column 2", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("Column 3", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("Column 4", Numeric, "Continuous", Format("Best", 12), Set Values([]))
);

mycols = {"a", "b", "c", "d"};
wait(1); // for demo purposes

For Each({colname, idx}, dt << Get Column Names("String"),
	Column(dt, colname) << Set Name(mycols[idx]);
);

You might also be already add the names in the import script but it might depend on your file

topic Re: How to provide column names manually in script for importing multiple text files? in Discussions

How to provide column names manually in script for importing multiple text files?

Re: How to provide column names manually in script for importing multiple text files?