You’re offline. This is a read only version of the page.
10
| Equipment Description | EquipmentID |
| LeakTester 2 ATEQ | KERO-A1-1684 |
| LeakTester 1 ATEQ | KERO-A1-1683 |
| EBC470 CaseUp Line | KERO-A1-1682 |
| Laser Welding - 1.2 | KERO-A1-1681 |
| EasyRouter | KERO-A1-1680 |
| MLL-3P + Extension | KERO-A1-1679 |
| EOL GM1 | KERO-A1-1674 |
| FCT | KERO-A1-1664 |
| Ebsomat 20-3 | KERO-A1-1661 |
| Surubelnita | KERO-A1-1655 |
| EOL Trane | KERO-A1-1654 |
| MUTE TERMINAL MACHINES | KERO-A1-1632 |
Share
Report
All responses (
Answers (
With(
{
_Data1:
ForAll(
Sequence(CountRows(Choices('NewLine Release Equipments'.'Equipment Description'))),
Patch(
Index(
Choices('NewLine Release Equipments'.'Equipment Description'),
Value
),
{No1: Value}
)
),
_Data2:
ForAll(
Sequence(Choices('NewLine Release Equipments'.EquipmentID))),
Patch(
Index(
Choices('NewLine Release Equipments'.EquipmentID),
Value
),
{No2: Value}
)
)
},
ClearCollect(
colEquipment,
ShowColumns(
AddColumns(
RenameColumns(
_Data1,
Value,
Equipment_Description
),
Equipment_ID,
LookUp(
_Data2,
No2 = No1,
Value
)
),
Equipment_Description,
Equipment_ID
)
)
)ClearCollect(
colCombinedEquipments,
ForAll(
colEquipmentDescriptions, // For each Equipment Description
{
EquipmentDescription: ThisRecord.Value, // The value of the Equipment Description
EquipmentID: LookUp(
colEquipmentIDs,
Value = ThisRecord.Value, // Match the description with the ID
Value // Return the corresponding Equipment ID
)
}
)
);ClearCollect(
colEquipmentDescriptions,
ShowColumns(
AddColumns(
'NewLine Release Equipments',
Equipment_Description,
'Equipment Description'.Value,
Equipment_ID,
EquipmentID.Value
),
Equipment_Description,
Equipment_ID
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
