Need help to unpivot a table, add descriptions and conditions
Hello everyone.
I've been trying to solve this problem for some days now and I think my mind is trying to complicate something that is probably very simple to achieve.
Context:
I have a table with different fields about the state of some vehicles at some point in the day (image 1)
I need to create an "Alarms" table in the UI that shows only some selected fields that were sent to me in an excel file. Tried to make a WildMatch in the early stage of Data Load but don't know if that's the right approach (image 3).
These fields only appear in the Alarms table if the alarm criteria (image 2) for each field is matched.
The alarm description (image 2) in the excel table provided to me must be one of the columns in this Alarms table
What I need to achieve:
Alarms table based of my general data table and mapping_alarms (for the AlarmDescription) with the following columns:
Timestamp
VesselNo
AlarmName
Value for the Alarm
AlarmDescription
Also, the general data table should not be deleted to feed the other KPIs and objects.
Is this something easily achieved?
Looking for some help and insights about this. Thank you in advance.
