Sum and Vlookup

[RT4]

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:

[randreag]

hi @RT4 

I'm not sure if I understood well whay you try to accomplish but I attached a workflow that takes all the sheets(except the first) and puts in one big table

I hope it helps

[Qiu]

@RT4 

The data is big.

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

[RT4]

Hello!

Thanks for your fast reply.

But I get an error at this configuration.

Could you please specify what should be there?

Thanks

[RT4]

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.