# Pairing Data according to criteria - Dictionary

**URL:** <https://forum.dynamobim.com/t/pairing-data-according-to-criteria-dictionary/8763>\
**Category:** Packages\
**Created:** [January 10, 2017, 10:00pm UTC](https://forum.dynamobim.com/t/pairing-data-according-to-criteria-dictionary/8763 "2017-01-10T22:00:23Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\
**Post date:** [January 19, 2017, 10:00am UTC](https://forum.dynamobim.com/t/pairing-data-according-to-criteria-dictionary/8763/7 "2017-01-19T10:00:26Z")

</div>

@Jorge_Villarroel

You would possibly be better off using a true database rather than Excel.  
By doing this, a simple SQL query, used in conjunction with GetParameter & SetParameter would do what you want

`SELECT [bars] from [table] where [pier]=pier AND [level]=level`

Refer [Using SQLite instead of Excel](https://forum.dynamobim.com/t/using-sqlite-instead-of-excel/4565)  
It might seem daunting, but is really quite easy.

---

_[View the full topic](https://forum.dynamobim.com/t/pairing-data-according-to-criteria-dictionary/8763)._
