Sum and Vlookup

Question

Hello!

Have a data table which needs to be filled with the tabs in it.

Similar to Vlookup.

The data needs to be taken from the tabs "Ohne Belegart", "Erstattung", "Gutschrift", "Rechnung", "Zahlung", "Anzahlung" by Combine column.

To fill columns H-L.

Anzahlung (G) is done with Vlookup. Was wondering if there is an option to do it with Alteryx.

Thanks for the assistance!

The Result Should look smth like that:

Analyse Data - Alteryx to share.xlsx

RT4 · Answer

Hi Aruiz,

thanks for the fast reply.

I get this configuration error.

Sorry if it was not clear from the beginning.

I need to fill Analyse Data tab in the columns G-L, by fields Combine and Restbetrag (MW) accordingly to the columns "Ohne" form the tab "Ohne Belegart", "Erstattung" from the tab "Erstattung" etc..

For Anzahlung i used vlookup, which worked pretty well, but the others might have duplicates so i was trying to use sumif and vlookup, but didnt really work.

RT4 · Answer

Hello!

Thanks for your fast reply.

But I get an error at this configuration.

Could you please specify what should be there?

Thanks

Qiu · Answer

@RT4

The data is big.

Continue on idea from @randreag , I added Join, which serves as VLoopup.

0202-RT4.yxzp