Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
vchilakamarthi
Contributor II
Contributor II

Oracle string to Postgres Boolean conversion

Hello,

I am looking to set up replication from Oracle DB as source to Postgresql DB as target for one table.
There is one column that is varchar2 on source(oracle) that I have to convert to boolean on target (postgres).

Can that be done using expression builder. If so is there any reference that you can point me to.

Thank you.

Labels (1)
2 Solutions

Accepted Solutions
vchilakamarthi
Contributor II
Contributor II
Author

I found this is working for me in expression builder.

CASE

WHEN option = 'Y' THEN true

WHEN option = 'N' THEN false

ELSE false 

END

View solution in original post

john_wang
Support
Support

Thank you for your great support! @vchilakamarthi 

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

2 Replies
vchilakamarthi
Contributor II
Contributor II
Author

I found this is working for me in expression builder.

CASE

WHEN option = 'Y' THEN true

WHEN option = 'N' THEN false

ELSE false 

END

john_wang
Support
Support

Thank you for your great support! @vchilakamarthi 

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!