Forum Discussion
Helper IITable data link up question
Hi Ericwhv ,
The solution is simple, but it's a bit complicated to tell, and I'll try to make it clear.
1.Create a custom column in your truck schedule table.
2.Use the Merge Queries feature to join the two tables based on the Lane column.
3.Add a custom column in the merged table to filter out the rows that match your needs.
4.Use the Group By feature to group the data by Lane and Departure columns, and use the Sum aggregation function to calculate the total weight.
5.Finally, duplicate the truck schedule table, note that it is not a reference, and then merge it inside based on the Lane column and the Departure column.
6.This is the expected result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ericwhv ,
The solution is simple, but it's a bit complicated to tell, and I'll try to make it clear.
1.Create a custom column in your truck schedule table.
2.Use the Merge Queries feature to join the two tables based on the Lane column.
3.Add a custom column in the merged table to filter out the rows that match your needs.
4.Use the Group By feature to group the data by Lane and Departure columns, and use the Sum aggregation function to calculate the total weight.
5.Finally, duplicate the truck schedule table, note that it is not a reference, and then merge it inside based on the Lane column and the Departure column.
6.This is the expected result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.