Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Mapping multiple (thousands) fields into NULL

Hi,

Is there a way to change the mapping of multiple fields into NULL but not one by one?

I've been dealing with almost 4,000 fields to change all to NULL.

Thanks.

Cha

Tags:
Former Member
replied

There are 2 ways to do this at mapping level:

1/. Select all fields in the target schema (use shift-click or right-click to do so), then right-click and select Properties... from the pop-up menu. Set Mapping to null.

2/. In the last Query transform before the target table: select all fields in the target schema (use shift-click or right-click to do so) and delete. Fields not included in the insert will get a null value by definition.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question