Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
pbellonch
Contributor II
Contributor II

Bit type extraction

Hello, Im tring to extract data from one table and I have problems in this process related of one column. The problem is in the DB i have configurated this table like a Bit but when I extract it, the column arribe in the data lake as a Boolean. This is normal or I can extract like a bit?

Thnaks 

Pau

Labels (2)
6 Replies
john_wang
Support
Support

Hello @pbellonch ,

Thanks for reaching out to Qlik Community!

Would you please share source and target Database Types, and a demo table creation DDL , 1 or 2 rows data, we are more than happy to confirm the behavior for you.

Regards,

John.

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

Hello, the source is Amazon RDS for SQL Server and the target a CSV file. I can't share with you the rows of the data, sorry. 

Regards 

Pau

john_wang
Support
Support

Hello @pbellonch ,

Thanks for the update. Would you please check if this is what you are looking for?

Wrong format when extract Boolean column 

Let me know if you need any additional assistance.

John.

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

Okey, So, Qlik extract the Bit columns as a Boolean format. But, I don't want to make transformations before to ingest the data in the data lake. It is possible? 

john_wang
Support
Support

Hello @pbellonch ,

We might transform the data then load into data lake, or load into data lake straightly without transformation and then convert the data types while consuming the data in data lakes. Both options should be fine.

Regards,

John.

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

" Qlik extract the Bit columns as a Boolean format. But, I don't want to make transformations before to ingest the data in the data lake. It is possible? "

Do you not want Replicate to do an implied transformation? Or do you not want to add a transformation of your own to the Replicate task?

What do you have in the CSV file? "true"/"False" or true/false ? What do you want? 0/1

Some things to investigate.

  • Some of the Source endpoints have "Map BOOLEAN to Replicate BOOLEAN data type (instead of STRING (5)) option in the Advanced tab". Is that available?  Check that out.

  • Global transformation rules, or per-table, per-column transformation. Change column datatype from BOOLEAN to INT1 

Hein.