topic Re: Bit type extraction in Qlik Replicate

Bit type extraction

pbellonch — Tue, 07 May 2024 12:31:39 GMT

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

Re: Bit type extraction

john_wang — Tue, 07 May 2024 12:35:04 GMT

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.

Re: Bit type extraction

pbellonch — Tue, 07 May 2024 13:06:00 GMT

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

Re: Bit type extraction

john_wang — Tue, 07 May 2024 13:11:05 GMT

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.

Re: Bit type extraction

pbellonch — Tue, 07 May 2024 13:22:12 GMT

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?

Re: Bit type extraction

john_wang — Tue, 07 May 2024 13:46:32 GMT

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.

Re: Bit type extraction

Heinvandenheuvel — Tue, 07 May 2024 20:40:39 GMT

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