Forum Discussion

Naushad123's avatar
Naushad123
Regular Visitor
6 years ago

Merge two tables, and update column header with data in specific column

Hi all, i have two tables Table 1 is about the allowances assign to specific designation Table 2 in emplyee payroll table     i want to create a column with specific allowances an...
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi Naushad123 , 

I am not clear about your requirement, it seems that you want to update  amount in table 2, right? I want to know which amount did you want to show for "Managing Director"?

 

If possible, could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading(you could typing the data or upload by OneDrive for Business ).

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Naushad123's avatar
Naushad123
Regular Visitor
6 years ago

Thanks dax, yes it is like that.i am sorry i double the table2, the first table1 with name desigallow, i want to update the amount specificaly for managing director like you said but in "Orderly Allow" column only, likewise Naib Qasid "integrated Allow" column have value of 450.

 

Table 1 Allowances record become column in Table2, and update with the amount mentioned in Table1, the criteria in Table 2 is Designation Column,

 

i hope i tried my best to make you understand.