You can mix and match data from different tabs using Lookup Single Row enrichment. This lets you pull data from other tables in your workspace into your current table. [1]
To set it up:
Choose the table to search
Select the target column
Pick your filter operator
Enter the row value to match
You can also merge columns to combine data from multiple columns into one. Just click Add Column → Merge Columns, then write a formula using / to combine your desired columns. [2]
If you need any more help with mixing and matching data or using Lookup Single Row enrichment, please let me know. Would you like to share more about what you're trying to achieve so I can assist further?
Got it - let's troubleshoot this. Can you tell me more about what specifically didn't work? For example:
Are you getting an error message when setting up the lookup?
Is the lookup running but not returning the data you expected?
Are you trying to pull data from different tabs within the same table or from completely separate tables?
Also, have you tried using Sculptor yet? It's our built-in AI tool in the top-right corner that can help you set up these lookups automatically. Give it a try and let me know if that helps or if you're still stuck! [1]
I’m sorry the lookup didn’t work as expected and I’m here to help if you need further assistance. Could you provide more details about the issue you’re facing or what you’re trying to accomplish with the data mix?
