Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Restas condicionadas

Friends;

I would ask your help for the next case.

I have a table that comes with the following columns documnet Type, Units, Invoice, now well what I do is subtract units Units when Document Type ZRE and ZVLO have the same number of Invoice.

Document Type Invoice Units

ZVLO April 1234

ZRE February 1234

In this case subtracting 4 ZVLO 2 ZRE but the condition is the same as is Invoice example.

I really appreciate your help much because I failed to do so.

Regards.

-------------------

Amigos;

quisiera pedir su ayuda para el siguiente caso.

tengo una tabla que viene con las siguientes columnas Documnet Type, Units, Invoice, ahora bien lo que quiero hacer es restar a Units las unidades cuando en Document Type ZRE y ZVLO tengan el mismo número de Invoice.

Document Type     Units     Invoice

ZVLO                    4          1234

ZRE                      2          1234

En este caso restar a 4 de ZVLO 2 de ZRE pero la condición es que Invoice sea el mismo como el ejemplo.

En verdad agradeceré mucho su ayuda ya que no he logrado hacerlo.

Saludos

3 Replies
Kushal_Chawda

Please share the sample data with expected output

Not applicable
Author

You expect this response?

Document Type     Units     Invoice

ZVLO                    2          1234

ZRE                      2          1234

Anonymous
Not applicable
Author

The expected response would be like Raúl

Document Type     Units     Invoice

ZVLO                    2          1234

ZRE                      2          1234

ZRE even that will not show the final data would only ZVLO .


Thank you very much for your help.