topic IF condition not workining properly app/script in App Development

IF condition not workining properly app/script

ruben_moya — Fri, 13 Jan 2023 08:39:08 GMT

Dear experts,

I'm having issues trying to find out why a simple if clause is not working.

This is the scenario:

Providers:
LOAD
if(ID_TipoRecurso_C= 'IMS', ID, ID_Long) as Provider_Key
,[ID]
,[ID_Long]
,[ID_TipoRecurso_C]
;
sql SELECT ID
, ID_Long
,[ID_TipoRecurso_C]
FROM XXXXXXXXXXXXXXXX;

I need to create a field that shows ID when the value for ID_TipoRecurso_C= 'IMS'.

I'vve confirmed that thee value in ID_TipoRecurso_C is actually 'IMS'

I've also tried to add the condition with a case in the sql part. ACTUALLY, WHEN I TRY THE QUERY DIRECTLY ON MY DATABASE IT WORKS PROPERLY.

Do you guys know what could be the problem here, it is quite a simple condition and it should be working correctly.

Thanks in advance.

Re: IF condition not workining properly app/script

vinieme12 — Fri, 13 Jan 2023 09:47:54 GMT

use Wildmatch() instead as it is case insensitive

if(Wildmatch(TRIM(ID_TipoRecurso_C,'IMS'), ID, ID_Long) as Provider_Key

or Index() to match avoiding garbage characters if any

if(index(UPPER(ID_TipoRecurso_C),'IMS'),ID, ID_Long) as Provider_Key

Re: IF condition not workining properly app/script

ruben_moya — Fri, 13 Jan 2023 09:55:16 GMT

Thanks @vinieme12 ,

I've tried your suggestions but both gave me the same result. Actually, in the example that I posted I had already checked that with the column '=if(ID_TipoRecurso_C= 'IMS', 'OK', 'KO')' and it proofs that the string 'IMS' is corrrect

Re: IF condition not workining properly app/script

vinieme12 — Fri, 13 Jan 2023 10:22:56 GMT

force as text

Providers:
LOAD
if(ID_TipoRecurso_C= 'IMS', TEXT(ID), TEXT(ID_Long)) as Provider_Key
,[ID]
,[ID_Long]
,[ID_TipoRecurso_C]
;
sql SELECT CAST([ID] as TEXT) as [ID] // as TEXT or as varchar)
,CAST([ID_Long] as TEXT) as [ID_Long]
,[ID_TipoRecurso_C]
FROM XXXXXXXXXXXXXXXX;

Re: IF condition not workining properly app/script

ruben_moya — Fri, 13 Jan 2023 11:15:54 GMT

Hi @vinieme12 , thanks a lot, it worked! Could you explain me why to understand the logic behind?

I realised that if i filtered the load to have just registers with ,[ID_TipoRecurso_C] ='IMS' the condition works.

Thanks a lot.