Integration HUB ETL staging table having empty fields

[pratiksha5]

I am trying to populate data with integration hub ETL class printer. 

I created one data source when I am loading the data cost is not getting populated in -prepare source data for mapping

 

I changed the data type from decimal to currency when I loaded the data in data source I can see the data in import set table. But in prepare source data for mapping it is not coming up. 

Please help 

[Ankur Bawiskar]

@pratiksha5 

so in excel it's decimal.

import set field should always be of type string.

So what is the target field type? and how are you setting it?

[pratiksha5]

On excel I changed it to currency, On the staging table also changed it to currency, and target data type is also currency 

[pratiksha5]

The data is populating in stagging table 

[Ankur Bawiskar]

@pratiksha5 

you should never field type in Import set.

It is meant to be kept as String always.

Target field is of type Currency right? then you can do this in onBefore transform script.

Don't use field map

Also ensure you set the currency; In example I have used USD

target.fieldName = "USD" + ";" + source.u_fieldName + "";

If my response helped please mark it correct and close the thread so that it benefits future readers.

[pratiksha5]

can we do it in the integration hub ETL? I have done after script in transform maps.