topic Re: [resolved] Convert boolean to integer in Talend Studio

[resolved] Convert boolean to integer

Anonymous — Fri, 29 Jul 2016 09:25:23 GMT

Hi everyone,
I need to do diverse calculation with a column which contain boolean value, but PowerBI isn't understanding boolean as integer.
I want to add a new column in my dimension, with the integer of this boolean value but my expression is always returning 0 even for un true boolean :
lookup1.Column1.equals("1")?1:0
(Column1 is a boolean)
Does anyone know where is my mistake, or how can I do it ?
Thank's in advance,
Julien

Re: [resolved] Convert boolean to integer

TRF — Fri, 29 Jul 2016 09:30:44 GMT

Hi,
If the datatype of lookup1.Column1 is boolean, you should write

lookup1.Column1 ? 1 : 0

Regards,
TRF

Re: [resolved] Convert boolean to integer

Anonymous — Fri, 29 Jul 2016 09:48:38 GMT

Hi,
Thank's a lot
It does work, but can you just explain me why please ? I'm a Java novice and I'd like to understand.
Thank's in advance,
Julien

Re: [resolved] Convert boolean to integer

Anonymous — Fri, 29 Jul 2016 09:55:06 GMT

It's a Java ternary operator and is equivalent to: -
if(lookup1.Column1) 1; else 0;
but you can't easily use an if statement in a mapping expression.
If you mean, why does you way not work, take a look at the Java help for Boolean.equal()

Re: [resolved] Convert boolean to integer

TRF — Fri, 29 Jul 2016 10:06:58 GMT

That's it!

Re: [resolved] Convert boolean to integer

Anonymous — Fri, 29 Jul 2016 10:13:46 GMT

Thank's a lot to both of you !!