Mapping multiple (thousands) fields into NULL

[former_member490928]

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

[Former Member · Accepted solution]

Hi Charity,

If this is a new mapping then you can select all the required columns, right click and make it as optional.

Once you make the columns as optional, Its not mandatory to map the column with NULL or any value(if you don't map anything then by default it takes NULL).

Try it once, Hope this helps.

Thanks,

Tanvi

[former_member490928 · Accepted solution]

Hi Ojha,

All the fields have current mappings, and all I need is to change all of them into NULL.

Is there a quick way to execute it?

Thanks.

Cha

[Former Member · Accepted solution]

Hi Charity,

If all the columns has to be remapped with NULL then you can delete the target columns mapping in query transform,Again connect the query transform to target table so you get the target columns in query transform again and then select all columns and right click make it optional. If you are trying this, Please be careful and take backup of the Dataflow so you don't loose the previous mapping in any scenario.

Thanks, Tanvi

[former_member187605 · Accepted solution]

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.

[former_member490928 · Accepted solution]

Thanks Dirk!