How to change data size in mapper

Designing Pipelines
#1

Hello Community,

I would like to change data size of below columns in mapper ,before loading data into SAP.

How can I achieve it?

image
image851×110 13.9 KB

image
image760×166 6.02 KB

#3

Hi @swatifunde ,

You can use Substring and set max length of each column.

For example, $SC_V5_STATUS.substring(0, 32) .

BR,
Marjan