.png){kind=logo}
Issue with Lookup Not Returning Records in Row Values
I did a lookup and inserted to columns in row value. And I know that there is a value for the second row value column that I inserted, but it showed no records found
I did a lookup and inserted to columns in row value. And I know that there is a value for the second row value column that I inserted, but it showed no records found
Hey David, thanks for reaching out! The reason why this is happening is because both columns contain data which is conglomerating into a value like what's shown below: "PICCASO (Privacy, InfoSec, Compliance, Culture, Awareness, Strategy, Ops)PICCASO (Privacy, InfoSec, Compliance, Culture, Awareness, Strategy, Ops)" Since this is the value being used to lookup agains the "Name" column in the other table, and your filter operator is "equals" there will not be a match. Even if this filter operator is contains, I would recommend sending this through some sort of Normalization column (which is free ;) as shown below in both tables to make sure this data is super clean. Let me know if this helps!
