receive string value and convert to bigdecimal to ... - Qlik Community

uzix · ‎2018-11-26

hi all,

hi have a question.

i receive this value as string :

1,000.36

and i must insert it in a db as NUMBER(16,2)

respecting the format:

#,###.##

before inserting in db.

what is the best way?

thank you very much!!!

Anonymous · ‎2018-11-26

The tMap component has BigDecimal as one of the available formats. You could use that along with the convertImpliedDecimalFormat() function.

ankit7359 · ‎2018-11-26

Greetings of the day,

Well, always remember you can cast your data-type.

So to cast from String to Integer. you can either use a Tmap or tconverttype components.

Tconverttype - you can auto-cast your data-types as per your schema specifications.

Tmap - you can change your data-type from one to another.

you can use this method to convert string to Integer -> Integer.parseInt(row1.columnname).

Pls reach out to the community if necessary.

Thanks,

Ankit

receive string value and convert to bigdecimal to be inserted in db as NUMBER(16,2)