Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2010-04-06 11:08 PM

Convert short and long numbers to Integers?

I have an access database and am moving data to a postgresql DB. Many of the fields in the access are listed as short or long. How do I convert to the Integer type in Postgresql?
Any suggestions are welcome.
Thanks.
Labels (2)
Labels
208 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2010-04-07 12:39 AM
Author

Hello
You can convert short/long to int/integer on tMap, for example:
on the expression of output column, type in 
(int)row1.columnName

Best regards
Shong
208 Views
0 Likes
Anonymous
Not applicable
‎2011-05-25 07:57 AM
Author

Shong!!
When i want to convert form long to int in tmap..but it throws me an error..saying it cant cast from long to int
208 Views
0 Likes
Anonymous
Not applicable
‎2011-05-26 11:37 PM
Author

Shong!!
When i want to convert form long to int in tmap..but it throws me an error..saying it cant cast from long to int

ah, the error message should be 'it can't cast from Long to int'!, this is because Long is an object, to get around it, uncheck the 'nullable' box on schema.
Best regards
Shong
208 Views
0 Likes