I have a separate table with 100 rows having column Keywords, can I merge/combine all this Keywords values into a one row in another table?
Hey there Amirali thanks for reaching out, there is a way to do this in Clay, the first step here would be to use a formula column in the table that contains your 100 rows of keywords and assign a value so that all the rows have the same value. For example you can go and make it so that every row will have a column that contains the word "PASS". Then what you'll do then is in the table where you want to merge them all into a single row, you will go create another column and enter that word that you added for all the other rows in the previous table, which in this case the word "PASS". Then you will use a "Lookup multiple rows in other table" integration and set it up set it up so that you're searching for the word "PASS" in the previous table and match it with the column that has the word "PASS" in this table. This will then bring the values from the previous table and add them to a single row. To then extract all these values into a single cell you would use a formula where you prompt it to pull the value for whichever field contains your keywords for every single entry in the lookup column and then this will extract them all and insert them all into a single step
LuisArturo what would be that formula in the first step?
in this case the formula could be something like "if column X has a value return 'PASS'". Where column X will be a column in your table that is always guaranteed to have a value here