topic Re: business analyts with two or more rules in Data Quality

business analyts with two or more rules

EmmanuelTrejo — Wed, 21 Feb 2018 22:54:40 GMT

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.

Re: business analyts with two or more rules

Anonymous — Wed, 21 Feb 2018 23:05:00 GMT

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.

Re: business analyts with two or more rules

EmmanuelTrejo — Thu, 22 Feb 2018 00:13:05 GMT

hi rhall_2_0, I want those three queries to be executed in a sql rule so that when I export the result I show all the results in a single view and only export a csv file and no not have to do each rule separately

"public"."Forwarder"."DiasDemoras"< 0

"public"."Forwarder"."FechaLimiteDevolucionVacio" <= '2016-01-01'

"public"."Forwarder"."ETD">"public"."Forwarder"."ETA"

Re: business analyts with two or more rules

Anonymous — Thu, 22 Feb 2018 00:34:35 GMT

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?

Re: business analyts with two or more rules

EmmanuelTrejo — Thu, 22 Feb 2018 16:48:23 GMT

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?

Re: business analyts with two or more rules

EmmanuelTrejo — Thu, 22 Feb 2018 16:49:25 GMT

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

Re: business analyts with two or more rules

EmmanuelTrejo — Thu, 22 Feb 2018 18:57:32 GMT

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

Regards

Re: business analyts with two or more rules

Anonymous — Thu, 22 Feb 2018 22:02:39 GMT

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 🙂