VLOOKUP not returning value

william_mollers

Hey Guys,

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

Akallman

Hi,
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.

JohnKoonsman

I am using VLOOKUP_UNNEST(csv['Media Buy Name'],[Media_Buy_Name],[Media_Buy_Key], true, {'DFA Data','FB Ads2020-2021'}) and can see the Media Buy Key in the preview but it does not evaluate and no data shows up in the Pivot table

Have also tried, TRIM,LOWER within my formula and still no joy.

Rochak

@JohnKoonsman, I am also stuck at the same point. Were you able to solve this? If yes, kindly share your response. Thanks and regards

SJPDS

Did you solve this ?