If dictionary key exists add new item to existing item array

I am having trouble adding items to a scripting dictionary in the way I want.

Basically, if the dictionary key exists then I want to add the corresponding item to the items already added for that key - in an array.

So far I have it working, but it only works up until two items and then just 'writes over'/ the previous:

Please Login or Register  to view this content.

Bizarrely when I do this and only concatenate the items into a string it works fine- like this:

Please Login or Register  to view this content.

But unfortunately a concatenated string is unsuitable for my needs. Any ideas on how I can add them into the array as I wish?

Thanks in advance

Array doesn't work like that, you'd be better off having a dictionary in each item and pushing into that - so you have a dictionary of dictionaries

Originally Posted by Kyle123

Array doesn't work like that, you'd be better off having a dictionary in each item and pushing into that - so you have a dictionary of dictionaries

Thanks Kyle I didn't realise I could not do that with arrays- I am learning VBA by doing so...

Anyway I think I can make it work by using a dictionary in each item, thanks!

Originally Posted by strud

I clicked solved a bit preemptively on my post about dictionaries of dictionaries.

I am not quite sure how having the item as a dictionary will help my situation, because I don't know how many items I wanted to add to the array, and I still want the items to be assigned to specific keys.

Sure, since you don't have an array you don't need to worry about how many items you want to add:

Please Login or Register  to view this content.

For those interested, aside from the dictionaries I also manged to get the same effect here- except there is duplication of the keys- but that was suitable for my needs:

Please Login or Register  to view this content.

Originally Posted by Kyle123

Sure, since you don't have an array you don't need to worry about how many items you want to add:

Please Login or Register  to view this content.

Thanks a lot Kyle!

Originally Posted by Kyle123

Sure, since you don't have an array you don't need to worry about how many items you want to add:

Sorry Kyle I am still confused - how would I now access & transpose the keys and items?

Like you would normally:

Please Login or Register  to view this content.

So that will return an array of all the items with a key of the first distinct item

Perfect, that's got it. I think I was over complicating it in my head. Thanks again!

as an option

Please Login or Register  to view this content.

What if the data contains ~?


Sent from my iPhone using Tapatalk

Thanks guys, I am probably being stupid here, but how would I get a list of all keys from the main dictionary with their items transposed in the columns adjacent?

So it would be all the keys from data(i, 1) and their items from (i, 2)...

I can't figure it out from what you have given me..

Originally Posted by Kyle123

What if the data contains ~?

Very unlikely, but, yes it can happen

Hi strud,

maybe a small sample

Ok attached- I need to be able to add items in an array I think so I can transpose them in the desired way

Perfect Norie thanks dude. I just couldn't work out hot adapt what they had given me.

Thanks again!

or

Please Login or Register  to view this content.