Multiple YTD files in excel.

[#1]

Hi Community,

I have multiple YTD files having data employee compensation in excel and which have to be loaded in Qlikview and difference between monthly YTD files is the monthly salary of each employee at employee ID level, which has to be calculated in script.

Please suggest way to calculate compensation in script.

I can do something like self join based on employee ID but in that case I believe I will have to change each field name manually for every file.

PFA the dummy data.

Regards,

Navdeep

[Gysbert_Wassenaar]

Can you post some examples?

[#3]

Uploaded.

[Gysbert_Wassenaar · Accepted solution]

Perhaps like in the attached example.

[#5]

Awesome, thank you pal.