topic Re: Change a field to blank on a fuse load in _Ask A Question for Item Management (IM)

Change a field to blank on a fuse load

jschumann — Wed, 05 Jan 2022 17:32:48 GMT

I did an export to change marketing information. I need one field that contains Recipient Category Destination to now be blank as the customer is no longer valid. How do you make a field blank when using append and not modify?

Re: Change a field to blank on a fuse load

CommunityJedi22 — Wed, 05 Jan 2022 22:07:34 GMT

Hello and good question. You actually cannot remove values via an Append operation but can do so with a Modify. The Modify is a full refresh of all values while an Append only updates what is populated that you upload.

Re: Change a field to blank on a fuse load

jschumann — Wed, 05 Jan 2022 22:09:29 GMT

Ok, riddle me this batman...if i only exported the ecomm playlist and do a modify, will it override everything? Like nutritional info and everything that wasn't exported?

Re: Change a field to blank on a fuse load

jcharles — Wed, 05 Jan 2022 22:09:49 GMT

Hello,

Extract the item and ONLY change the field you wished changed using a Modify. A modify will refresh every field so anything that remains the same in the sheet it will overwrite with the same information. Blank out the Recipient Category Destination and it should clear it.

Re: Change a field to blank on a fuse load

jschumann — Wed, 05 Jan 2022 22:12:00 GMT

bummer. ok...thank you