Pairing Data according to criteria - Dictionary

Packages
1

Hi All,

I’m trying to put some information in a wall from a database I have in an excel sheet.

The walls selected (Select Model Elements) have the same pier number (tag) to identify, this information I can get easly (Element.GetParamaterValueByName). Also I get the “Top Constraint” value with the same node to identify the element according to story level.

I want to “search” in my Excel Sheet by Pier Number and get the info from Number of Bars and Bar Diameter related to each story.

Here is an image to illustrate what I’m looking for:

imagen.png1010×836 240 KB

I took the example from @Vikram_Subbaiah in LOGIC If value matches a value in a dictionary , append associated value but I only can relate according to story levels.

Capture.png2932×1046 164 KB

Any suggestions will be appreciated.

Thanks in advance.

2

Not sure I totally get your issue, but there’s a node called Element.FilterByLevel in Chynamo. Is this what you need?

3

@Yna_Db, Hi;

The package recommended is a good tool, but for my issue I only need to make 2 filters, I think I managed to do it by this Filter.ByBooleanMask node and the do the filter by stories:

Capture2.png3618×1430 352 KB

Any suggestions?

Thanks in advance!

4

@Jorge_Villarroel

One way could be to join the wall number and the story in one string ( for both the walls and the data coming from excel).

Then search every element of list 1 in list 2 (see picture) and find the index.

From there it’s quite easy use the Element.SetParameterByName node.

I hope this make sense.

Pasted image1301×729 103 KB

5

I did not replicate this situation but to me, a Dictionary.ByKeysValues node (spring nodes) makes sense here: Walls have a tag (=keys) to identify elements in Excel sheet (=values), and you need to search by ‘Pier Number’ (=search keys). See in the thread you mentioned:

1 Like
6

Thanks. I’ll take a look at this.

Regards

7

@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
It might seem daunting, but is really quite easy.

1 Like
8

You can use dictionaries if you don’t want to get into SQL as Andrew is suggesting. Something like this:

Pasted image1849×819 278 KB

2 Likes
9

Thanks @Andrew_Hannell. I didn’t know about those databases. I’ll give them a try.

Dear Regards.

10

Thanks @jostein_olsen, I will try both of the suggested options and compare from which I could get a faster response.

Thanks a lot for your time.

Dear regards.