Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
VLOOKUP not returning value


Hey Guys,
this vlookup returns a null value when I enter in the media buy name... WHY!!!!! ??

this vlookup returns a null value when I enter in the media buy name... WHY!!!!! ??

Tagged:
Comments
Actually I have almost the same problem when using VLOOKUP_UNNEST. VLOOKUP_UNNEST(csv['Media Buy Name'],'Media Buy Name', 'Media Buy Key', {'FB Ads2020-2021','DFA Data'})
The syntax is OK but the evaluation not.
Error while evaluating formula VLOOKUP_UNNEST(csv['Media Buy Name'],'Media Buy Name', 'Media Buy Key', {'FB Ads2020-2021','DFA Data'}) for field 'media_buy_key': CompilationException - VLOOKUP_UNNEST(csv['Media Buy Name'],'Media Buy Name', 'Media Buy Key', {'FB Ads2020-2021','DFA Data'}): No handler found for dim key Media Buy Name (at line 1, column 1). --> Caused By: VLOOKUP_UNNEST(csv['Media Buy Name'],'Media Buy Name', 'Media Buy Key', {'FB Ads2020-2021','DFA Data'}): No handler found for dim key Media Buy Name (at line 1, column 1)
The datastream type is Ads for both FB Ads2020-2021 and DFA Data.