[FAQ000165]Is there a way to import only some of the items from a CSV file?

Q

I would like to create a CSV file from a certain system and link the data to CELF,

but some of the items (columns) are different and I cannot import the data as it is.

Is there a way to import only the necessary items (columns) from

a CSV file?

A

Once you have set the contents of the CSV file on the CELF sheet,

you may want to prepare only some of the items and then import them into the table.

1. Set the contents of the CSV file on the CELF sheet

with the "Set CSV file data as the starting point [ ]" action.

2. Use the "Delete column [ ] from column position [ ]" action

to delete columns of items (columns) that are not needed.

3. Register the table data on the sheet of CELF

using the "Repeat if [ ] is satisfied" action

and the "Register data in table" action.