Forum Discussion

Raj2410's avatar
Raj2410
Helper I
3 years ago

Need help

One table has unique value and other table has multiple dates for the unique value how to bring the multiple value to one coloumn in a new table
Need Help
Raj2410's avatar
Raj2410
Helper I
3 years ago
Table 2  Table 1  
Area/RegionTerritoryDistrictOfficeContract No.Equipment No.NA CODENotif #Work DateTOTAL SA HOURS  Area/RegionTerritoryDistrictOfficeContract No.Equipment No.Base Penalty value% penaltyNA CODE  
A04B10D8585104200008990M0052580BRPFL230117054700002141/17/20231.6  A04B10D8585104200008990M0052580 $                      35830%BRP  
A04B10D8585104200008990M0052580BRPFL230202133500002002/2/20230  A04B10D8585104200008990M0052581 $                      35830%BRP  
A04B10D8585104200008990M0052580BRPRP51335180692/6/20231.4  A04B10D8585104200008990M0052582 $                      35830%BRP  
A04B10D8585104200008990M0052580BRPRP51329116522/6/20231.5  A04B10D8585104200008990M0052583 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPPX0100193313411/9/20231.4  A04B10D8585104200008990M0052584 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPPX0100194371212/14/20231  A04B10D8585104200008990M0052587 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPRP51329116532/14/20231.4  A04B10D8585104200008990M0052588 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPRP51335180702/14/20231.6  A04B10D8585104200008990M0052589 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPPX0100193313401/12/20231  A04B10D8585104200008990M0052590 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPPX0100194371202/13/20230.9  A04B10D8585104200008990M0052591 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPRP51329116542/13/20231.4  A04B10D8585104200008990M0052592 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPRP51335180712/13/20231.4             
A04B10D8585104200008990M0052583BRPPX0100193528691/5/20230.5             
A04B10D8585104200008990M0052583BRPPX0100194838062/7/20230.7             
A04B10D8585104200008990M0052583BRPRP51329116552/7/20231.2             
A04B10D8585104200008990M0052583BRPRP51335180722/7/20231.4             
A04B10D8585104200008990M0052583BRPPX0100195578583/6/20231.3             
A04B10D8585104200008990M0052584BRPPX0100192702601/10/20230.9             
A04B10D8585104200008990M0052584BRPPX0100195021822/15/20230.6             
A04B10D8585104200008990M0052584BRPRP51329116562/15/20231.5             
A04B10D8585104200008990M0052584BRPRP51335180732/16/20231.3  Result visual I want
A04B10D8585104200008990M0052587BRPPX0100191517871/6/20230.5             
A04B10D8585104200008990M0052587BRP715458321/25/20230  Area/RegionTerritoryDistrictOfficeContract No.Equipment No.Base Penalty value% penaltyNA CODEWork DateTOTAL SA HOURS
A04B10D8585104200008990M0052587BRP715725661/30/20230  A04B10D8585104200008990M0052580 $                      35830%BRPJan-231.6
A04B10D8585104200008990M0052587BRP715938582/2/20230  A04B10D8585104200008990M0052587 $                      35830%BRPFeb-232.9
A04B10D8585104200008990M0052587BRPPX0100192241722/27/20233.3  A04B10D8585104200008990M0052591 $                      35830%BRPMar-230
A04B10D8585104200008990M0052587BRPPX0100192942593/3/20230.4             
A04B10D8585104200008990M0052588BRP715156391/19/20230             
A04B10D8585104200008990M0052588BRPPX0100191517861/24/20230.4  A04B10D8585104200008990M0052580 $                      35830%BRPJan-230.5
A04B10D8585104200008990M0052588BRPPX0100192942583/6/20230.7  A04B10D8585104200008990M0052587 $                      35830%BRPFeb-233.3
A04B10D8585104200008990M0052589BRPPX0100191548931/6/20230.6  A04B10D8585104200008990M0052591 $                      35830%BRPMar-230.4
A04B10D8585104200008990M0052589BRPPX0100192300872/17/20230.5             
A04B10D8585104200008990M0052590BRPPX0100191548921/19/20230.5             
A04B10D8585104200008990M0052590BRPPX0100192300882/17/20230.6  A04B10D8585104200008990M0052580 $                      35830%BRPJan-231.2
A04B10D8585104200008990M0052590BRPPX0100192995353/8/20233  A04B10D8585104200008990M0052587 $                      35830%BRPFeb-230.6
A04B10D8585104200008990M0052591BRPPX0100191394661/4/20231.2  A04B10D8585104200008990M0052591 $                      35830%BRPMar-2342.2
A04B10D8585104200008990M0052591BRPPX0100192133572/9/20230.6             
A04B10D8585104200008990M0052591BRPRP51336709893/7/20238             
A04B10D8585104200008990M0052591BRPRP51336709893/7/20238             
A04B10D8585104200008990M0052591BRPRP51336709893/7/20232             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20233.5             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20237.1             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20236.4             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20237.2             
A04B10D8585104200008990M0052592BRPPX0100191394671/9/20230.8             
A04B10D8585104200008990M0052592BRPPX0100192133582/9/20230.6