# Look Up Table For Fault Messages

**URL:** <https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314>\
**Category:** Ignition\
**Created:** [July 26, 2022, 3:28pm UTC](https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314 "2022-07-26T15:28:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\
**Post date:** [July 26, 2022, 3:28pm UTC](https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314/1 "2022-07-26T15:28:29Z")

</div>

Hello everyone,  
Thanks in advance for the help. I have a CIP fault list in an excel table. I want to put this into Ignition as a table to reference and look up fault messages to be displayed on an HMI screen. What is the best way to take the excel table with all of the existing faults and put it into a table (or maybe UDT?) in order to be referenced?

-William

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 26, 2022, 3:42pm UTC](https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314/2 "2022-07-26T15:42:03Z")

</div>

Put it into a memory dataset tag. Then you can use `lookup` expressions to get the text for a code.

---

<div class="post-metadata">

**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\
**Post date:** [July 26, 2022, 3:45pm UTC](https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314/3 "2022-07-26T15:45:44Z")

</div>

I currently have a memory dataset tag going right now. However, I can’t seem to copy my table from excel using the clipboard.

I get this error: java.lang.IllegalArgumentException: CSV invalid format: expected #NAMES on line 1  
I’m not sure how to use this clipboard correctly and what format it needs, but I can’t find any info on that in the forum or manual.

Thanks.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 26, 2022, 3:48pm UTC](https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314/4 "2022-07-26T15:48:40Z")

</div>

Make a sample row in your dataset. Copy it to the clipboard and paste into your favorite editor. You will see the header requirements. Export your Excel as CSV. Paste the parts you need from that into the sample export. _ **Adjust the number of rows specified in the header.** _ Copy the whole thing back to the clipboard, and paste back into the Ignition dataset editor.

---

<div class="post-metadata">

**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\
**Post date:** [July 26, 2022, 3:51pm UTC](https://forum.inductiveautomation.com/t/look-up-table-for-fault-messages/62314/5 "2022-07-26T15:51:27Z")

</div>

I will give that a try, thanks so much.