Edit a file already imported

claudia_figuera

Hi!

I would like to know if there is any possibility to edit a file (like excluding a column, for instance) once I have clicked on Import. Can someone help me? Moreover, can I remove this file without accessing to my finder and files?

 

Thanks a lot in advance.

 

Claudia

Telcontar120

There are multiple ways of doing what you are suggesting, depending on how you imported the data and whether you want the change to be permanent.

 

Perhaps the easiest solution is that you can always eliminate any number of attributes from your dataset using the "Select Attributes" operator.  This will only affect the copy in memory when running the process.  If you want to go back and overwrite the data you originally imported with this smaller dataset you would then need to add another Store operator to do that.

 

If you want to skip certain columns when importing, there is a check box when using the wizard (with Read CSV or Read Excel, for example) for each column--unchecking that will skip that column.  Once you have run the wizard once, this can be edited in the import metadata available through the parameter window.