Bit type extraction

[pbellonch]

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

[john_wang]

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.

[pbellonch]

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]

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.

[pbellonch]

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]

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.

[Heinvandenheuvel]

" 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.