Easy import template missing column

[farci]

Hi Team,

I have about 30 plus column in my table I want to import or update data into the table using Easy import, however I do not get the required columns which I need to update/insert in the template that gets downloaded when I select the option create template, I am not talking about fields such as video, images which gets excluded while I create a template.

Below are the fields that shows in my template even after selecting the option (Include all fields in the template?)

Could you please let me know how to include the fields in the template. I searched in the community and googled it but didn't found an answer yet.

How can I modify the template to see only those fields which are needed when I download the template.

Regards,

Narmi

[Jitu Sharma]

Hi Narmi,

You can get all fields from table using easy import. Please select the Check Box "Include all fields in the template?".

"

(Optional) Clear the Include all fields in the template? check box to include only columns that appear in the list in the template.

Leave this check box selected to include all columns from the table in the template, even those columns that are hidden in the list.

"

Please refer the SNOW doc:Download an import template.

Thanks,

Jitendra Sharma

[farci]

Hi Jitendra,

Thank You for the response, I did tried clicking on the check box to include all the columns but to no avail.

I am well versed in using transform maps and data source but I do not wish to go that route.

For a layman it is quite easy for creating the template and utilizing it for both insert and update.

Please let me know how I can include the fields in the template which I need.

Regards,

Narmi

[Jitu Sharma]

Hi Narmi,

"Include all the columns" check box is working in my instance.

Second option for Easy import :If you need all fields then you need to personalize list column and add all required field in list and save it then create template.

Thanks,

Jitendra Sharma  

[farci]

Hi Jitu,

I had already personalized it but its not working. I am working on scoped application and my tables are not extended to any base tables.

Regards,

Narmi