business analyts with two or more rules

Four Stars

business analyts with two or more rules

Saludos cordiales a todos, estoy llevando a cabo un proyecto en donde se requiere hacer mas de una clausula where en una misma tabla y que las dos o mas condiciones se cumplan y muestre el resultado.

 

Saludos cordiales.

 

Sixteen Stars

Re: business analyts with two or more rules

Can you give an example of what you want. I *think* you are asking about how to return values from a conditional query where at least 2 of the 3 conditions are met. You mention a table. Are you talking about a SQL query?

 

It would be useful to try to ask questions in English on here. I know English isn't your first language, but it will mean that more people can potentially help. If you struggle with English, then it also helps to see data examples. In some cases showing data examples (expected source and target) helps a lot more than brilliant English.

Four Stars

Re: business analyts with two or more rules

 hi 

 

 

Sixteen Stars

Re: business analyts with two or more rules

You can write whatever SQL you want to use inside the t{Database}Input components. 

 

A really simple way of doing this is to use the following WHERE Clause in your SQL query...

 

WHERE ("public"."Forwarder"."DiasDemoras"< 0 AND
"public"."Forwarder"."FechaLimiteDevolucionVacio" <= '2016-01-01') OR
("public"."Forwarder"."DiasDemoras"< 0 AND
"public"."Forwarder"."ETD">"public"."Forwarder"."ETA") OR
("public"."Forwarder"."ETD">"public"."Forwarder"."ETA" AND
"public"."Forwarder"."FechaLimiteDevolucionVacio" <= '2016-01-01') 

All of the data that meets at least 2 of the 3 criteria will be returned by the query. Is that what you want?

 

Four Stars

Re: business analyts with two or more rules

exacto, eso es lo que quería hacer, muchas gracias; otra cuestión es posible añadir una columna para identificar que fila cumple con alguna de las dos condiciones y si es posible exportar los datos de tal manera que se puedan obtener las gráficas que nos muestra dq?

Four Stars

Re: business analyts with two or more rules

Exactly, that's what I wanted to do, thank you very much; another question it is possible to add a column to identify which row fulfills one of the two conditions and if it is possible to export the data in such a way that the graphs shown by dq can be obtained

Four Stars

Re: business analyts with two or more rules

rilhia, I wondered if you know how can connect talend data quality with tableau

 

Regards

Sixteen Stars

Re: business analyts with two or more rules

I'm afraid I do not really do a lot with Data Quality and don't use tableau. It is not really a good idea to ask other questions on the one thread as it leads to the forum becoming very confusing for people searching for similar answers to their questions. Can you raise your secondary questions in new threads (appropriately titled) and then specialists in those areas will be able to find you easier. Also, if this answered your original question, can you accept the answer? Thanks :-)