I have a dimension “Self Served” that I get from an extract directly intro a transaction list A, in this transaction list A I have another dimension “Client ID” that is shared with another transaction list B, and I added another column in transaction list B to get the dimension “Self Served” but I get an error, is there a way to connect both transaction lists with something similar to a vlook up in Excel? I dont want to keep importing or manually adding “Self Served” into the dimension “Client ID” so I can use the function ITEM. I am trying to automate the data so it comes directly from the extracts.
Thank you very much for your insights!
Best answer by francoisView original