Currently having an issue where I I need to append a Category field to Google Analytics based on common SKUs. If this was in excel, I could do vlookup and get the strings to match. I have been trying to use Lookup(), but I can't get it to work. I am able to get them to connect via Data Relationships, but I am avoiding that for other reasons this time.
I can't move this to a Dimension because of the ATTR function and when I remove it, the equation doesn't work.
Any help would be appreciated!
Are you doing this across data blending? Is it possible to share a small sample of the workbook here as a .twbx file?