DTW - empty fields

[Former Member]

Hi Dear;

in Data transfert workbench, which character i have to use in excel to delete the contant of a certain field (empty).

thank you Dear.

[former_member184566 · Accepted solution]

Hi

In 2004 you use a slash. Here is an extract

You must prepare the data files to be updated based on the data file templates. All the key fields in the templates have to be filled. For fields that you want to update, fill them with new data. For fields that you do not want to change, leave them empty. For fields that you want empty, fill them with /.

It is in the 2004 help files.

Hope this helps

[Former Member · Accepted solution]

thank you Louis;

it's ok.