topic Re: If statement in Connectivity & Data Prep

If statement

Anonymous — Wed, 07 Feb 2018 10:37:07 GMT

Hello,

Can you please help me in the formula for IF statement.

I have a column with three numbers Column A = 30000; 27000; 23600

I want to make column out of this data using IF statement

like (IF(ColumnA=30000), "Megatruck", IF((ColumnA=27000), "standard", error))

Thank you in advance,

Sachin

Re: If statement

Anonymous — Wed, 07 Feb 2018 11:24:35 GMT

Looks like the brackets are wrong, maybe try something like this :

IF ( ColumnA=30000

, "Megatruck"

, IF ( ColumnA=27000

, "standard"

, error )

)

Re: If statement

Anonymous — Wed, 07 Feb 2018 11:27:58 GMT

No it doesnt work

here is the formula from qlik sense

IF ( [Chargable weight/PTasab_cont_]=30000, "Megatruck", IF ( [Chargable weight/PTasab_cont_]=27000, "standard", "error" ))

It gives "megatruck","standard","error"is not valid

Re: If statement

Anonymous — Wed, 07 Feb 2018 11:32:50 GMT

Is you first field actually called

[Chargable weight/PTasab_cont_]

Or do you need to divide one field by another like this :

[Chargable weight] / [PTasab_cont_]

Re: If statement

Anonymous — Wed, 07 Feb 2018 11:36:49 GMT

The field is called

[Chargable weight/PTasab_cont_]

its a column name

Re: If statement

Anonymous — Wed, 07 Feb 2018 11:47:40 GMT

In that case I don't know what is adrift, could you post full load statement from the script ?

Sometimes a typo elsewhere can cause an ok bit to error out.

Re: If statement

Anonymous — Wed, 07 Feb 2018 11:54:52 GMT

From the column (chargable weight) which has numbers, I need to create a new column, it can be dimension od measure. Where i need to get or show 30000=megatruck, 27000 standard & 23400= error.

I hope this helps

Re: If statement

Anonymous — Wed, 07 Feb 2018 12:01:56 GMT

Personally I would create a new field for it in the back end script.