I’m trying to import some data from excel using the Dictionary.ByKeyValues node. I noticed that when I use a list of search keys, it returns null values but when I use a single string…it’s successful. I’d appreciate any ideas.
@okarim6RZ7U - can you try the out-of-the-box dictionary nodes instead?
Should it matter though? I had used the same node earlier for another graph…just different excel files. It worked.
I don’t use the out-of-box version. The springs version is much more simple to use.
Never had an issue with this node…Can you maybe show the inputs to the keys and values as well?
Cheers,
Matt
But you are feeding it nulls…
Keys need to be unique values.
1 Like
I removed the null values but still the same issue.
Key’s also need to be a string, so can you chek with an Object.Type node and a List.UniqueItems node to ensure they are all strings?
Yes, but the keys still need to be unique values.
Maybe if you group by key, and then do a list count, you can see fi you have duplicate values.
1 Like