🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

what is wrong in this function?

cdaponte

Is very general the question, but maybe you can answer it. Thanks!

if(Tercerizado==0 && "Prodcuto Generico"=="PV" && [Vector de Mora Reducido]>3,"MORA TARDIA-PV",

if(Tercerizado==0 && contains("Prodcuto Generico","CBU-NO") &&[Vector de Mora Reducido]>3 ,"MORA TARDIA-CBU-NO BARRIDO",

if(Tercerizado==0 && contains("Prodcuto Generico","CBU-BA") && [Vector de Mora Reducido]==4,4,

if(Tercerizado==0 && contains("Prodcuto Generico","CBU-BA") && [Vector de Mora Reducido]==5,5,

if(Tercerizado==0 && contains("Prodcuto Generico","CBU-BA") && [Vector de Mora Reducido]>5,"MAS DE 5"," ")))))

Find more posts tagged with

AI Studio

Accepted answers

tftemme

Hi @cdaponte

As Prodcuto Generico is an attribute name you have to put it in brackets, not in quotes. Currently not the value of the attribute is evaluated but the actual String in the quotes.

Best regards,
Fabian

All comments

cdaponte

I´m executing it but it does not give me any result! And i don´t know why. I getting crazy!

varunm1

Can you inform what type of attributes are (Tercerizado, Prodcuto Generico and Vector de Mora Reducido)? By type, I mean whether they are text or polynomial or number or any other?

Also, can you share your XML process and sample dataset?

cdaponte

Tercerizado is nominal, Producto generico Polynominal and Vector de Mora Reducido is integer.

<?xml version="1.0" encoding="UTF-8"?><process version="9.3.001">

</context>

<parameter key="asd" value="if(missing(Tercerizado) && "Prodcuto Generico"=="PV"&&[Vector de Mora Reducido]>3,"MORA TARDIA-PV",
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-NO BARRIDO"&&[Vector de Mora Reducido]>3,"MORA TARDIA-CBU-NO BARRIDO",
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-BARRIDO" && "Vector de Mora Reducido"==4,4,
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-BARRIDO" && "Vector de Mora Reducido"==5,5,
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-BARRIDO" && [Vector de Mora Reducido]>5,"MAS DE 5"," " )))))"/>

</list>

</operator>

</operator>

</operator>

<parameter key="Vector de Mora Real" value="if(missing(Tercerizado) && "Prodcuto Generico"=="PV"&&[Vector de Mora Reducido]>3,"MORA TARDIA-PV",
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-NO BARRIDO"&&[Vector de Mora Reducido]>3,"MORA TARDIA-CBU-NO BARRIDO",
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-BARRIDO" && "Vector de Mora Reducido"==4,4,
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-BARRIDO" && "Vector de Mora Reducido"==5,5,
if(missing(Tercerizado) && "Prodcuto Generico"=="CBU-BARRIDO" && [Vector de Mora Reducido]>5,"MAS DE 5",
if(missing(Tercerizado) && [Vector Mora]== 0,0,
if(missing(Tercerizado) && [Vector Mora]==1,1,
if(missing(Tercerizado) && [Vector Mora]==2,2,
if(missing(Tercerizado) && [Vector Mora]==3,3,
if(missing(Tercerizado) && [Vector Mora]==4,4,
if(missing(Tercerizado) && [Vector Mora]==5,5,
if("Producto Generico"=="CBU-BARRIDO" && Tercerizado=="MORA TARDIA","MAS DE 5",
if("Producto Generico"=="CBU-BARRIDO" && missing(Tercerizado) && [Vector Mora]>5 ,"MAS DE 5",
if(contains(Tercerizado,"WEISFELD")||contains(Tercerizado,"QUIEBRA")||contains(Tercerizado,"Weisfeld")||contains(Tercerizado,"LLECI")||contains(Tercerizado,"SAGUES")||contains(Tercerizado,"HADAD") ||equals(Tercerizado,"JUDICIAL")||equals(Tercerizado,"GESPO JUDICIAL")||equals(Tercerizado,"GLUPO JUDICIAL")||equals(Tercerizado,"Judicial") ,"ESTUDIO JUDICIAL",
if(Tercerizado=="MORA TARDIA" && "Producto Generico"=="PV", "MORA TARDIA-PV",
if(Tercerizado=="MORA TARDIA" && "Producto Generico"=="CBU-NO BARRIDO","MORA TARDIA- CBU-NO BARRIDO",
if(contains(Tercerizado,"COBRO"),"ARGENCOBRO",
"ESTUDIO EXTRAJUDICIAL")))))))))))))))))"/>

</list>

</operator>

<parameter key="asdd" value="if(Tercerizado==0 && "Prodcuto Generico"=="PV" && [Vector de Mora Reducido]>3,"MORA TARDIA-PV",
if(Tercerizado==0 && contains("Prodcuto Generico","CBU-NO") &&[Vector de Mora Reducido]>3 ,"MORA TARDIA-CBU-NO BARRIDO",
if(Tercerizado==0 && contains("Prodcuto Generico","CBU-BA") && [Vector de Mora Reducido]==4,4,
if(Tercerizado==0 && contains("Prodcuto Generico","CBU-BA") && [Vector de Mora Reducido]==5,5,
if(Tercerizado==0 && contains("Prodcuto Generico","CBU-BA") && [Vector de Mora Reducido]>5,"MAS DE 5"," ")))))"/>

</list>

</operator>

</list>

</operator>

</operator>

</process>

</operator>

</process>

tftemme

cdaponte

Hi @tftemme i have already try putting Producto generico in brackets but it does not work...

Image: https://us.v-cdn.net/6030995/uploads/editor/zm/c2vm0gvvu2ij.png

cdaponte

i was writting worng producto generico!!

Thanks!!!

varunm1

Thanks for sharing the process, can you share sample dataset? I see that you asked the same question earlier and we replied with similar answers. If you could provide a sample dataset we can debug.

You can also set break point on the second generate attributes by right clicking on the operator and click on "breakpoint before". Run the process and see if all the attributes you are using in the generate attribute are present in the example set.