Hello, I’m stuck trying to figure out how to format an email attachment according to specific template. Expressions in image #1 produces the output in image#2 (which is working well). But the team wants information displayed according to image #3. I am at a loss writing the correct expressions that will get data from the two tables to display correctly. The information are coming from two tables - Orders and Order Details.
Orders table has the following columns: Order Id [Key] Order status Customer name Dealer Order Date Requested Delivery Date Sales Rep Tractor Model Hyd Spool Qty Total Welding Hrs Total Assembly Hrs
Order Details table has columns: OrderDetailId [key] Order Id Category (ex Tanker, PTO, Pump,
Product Id Product Code Door Rear view Remarks
Pls, what is the correct expression to use?