skipEmptyColumns
Indicates whether to skip empty and missing XML tags. To use with conceptual objects, ensure that every level in the conceptual object has at least one record.
skipEmptyColumns=true. Default.
skipEmptyColumns=false. Includes all empty and missing tags in the input XML for insert and update actions.
To skip empty columns (shipEmptyColumns=true) in a conceptual object that has Country > State > City, all constituent objects must have at least one record, as in the following examples.
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_1</St_Name>
<City>
<City_Name>City_Name_a</City_Name>
</City>
</State>
</Country>
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_2</St_Name
<City>
<City_Name>City_Name_b</City_Name>
</City>
</State>
</Country>
For a conceptual object that does not have a record in every level, set the value of skipEmptyColumns as false.
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_1</St_Name>
<City>
<City_Name>City_Name_a</City_Name>
</City>
</State>
</Country>
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_2</St_Name
<City>
<!-- City record not present for the country -->
</City>
</State>
</Country>