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.
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.
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
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?
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?
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
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 🙂
