topic Re: Wrong format when extract boolean column in Qlik Replicate

Wrong format when extract boolean column

pbellonch — Wed, 24 Apr 2024 07:38:13 GMT

HEllo,

I extract one table that have one column in the database using 1 or 0 (boolean). During the extarction, Qlik modify this value and write False or True. Could you help to fix this, the business team wants 0 or 1.

Thanks

Pau

Re: Wrong format when extract boolean column

john_wang — Wed, 24 Apr 2024 07:54:52 GMT

Hello @pbellonch ,

Welcome to Qlik Community forum and thanks for reaching out here!

Would you please share what's the source and target endpoints database type? We'd like to confirm the behavior for you.

Regards,

John.

Re: Wrong format when extract boolean column

john_wang — Wed, 24 Apr 2024 07:54:52 GMT

Hello @pbellonch ,

Welcome to Qlik Community forum and thanks for reaching out here!

Would you please share what's the source and target endpoints database type? We'd like to confirm the behavior for you.

Regards,

John.

Re: Wrong format when extract boolean column

pbellonch — Wed, 24 Apr 2024 08:43:53 GMT

Hello John, yes the target endpoint is a file (csv) and the source is Amazon RDS for SQL Server.

Thanks

Pau

Re: Wrong format when extract boolean column

john_wang — Wed, 24 Apr 2024 08:45:10 GMT

Hello @pbellonch ,

Thanks for the information, please allow me some minutes.

Regards,

John.

Re: Wrong format when extract boolean column

john_wang — Wed, 24 Apr 2024 09:29:46 GMT

Hello @pbellonch ,

There is no BOOLEAN data type in SQL Server, I think you are using BIT data data type in your tables.

By default Qlik Replicate maps the BIT to Boolean data type that's why you get the behavior.

You may change the data type in transform from default BOOTEAN to INT1. In my labs the table was created as:

CREATE TABLE testboolean (id integer NOT NULL PRIMARY KEY,name char (20), bl bit);
insert into testboolean values (2,'test',1);
insert into testboolean values (3,'test',0);

So I changed the column "bl" data type to INT1 as:

Then in the File target I got:

"id:INT4","name:STRING(20)","bl:INT1"
2,"test",1
3,"test",0

Hope this helps.

John.