create new columns in loop and join to existing data

Hi,

This is my input data

and this is my lookup table

if the word "beep" is present in the data under Field_6 then the column Tones will be updated as 1 else 0 and joined with the main data. Same for the rest.

So is it possible to dynamically create the columns with the respective filters ?

Thanks for the help..

Macros

Help

Join

Accepted answers

gabrielvilella

Hi @Hilda, here is one way of doing this.

Count.yxmd

atcodedog05

Hi @Hilda

Here is how you can do it.

Workflow:

Hope this helps : )

count matches.yxmd

All comments

binu_acs

@Hilda please provide some sample data and expected result

Hilda

sample data

Data

Cat is a domestic animal. Cat and dog are very beautiful.cat is friendly

Cat is a domestic animal. Cat and dog are very beautiful.dog is more friendly tan cat

lookup table

Search	Bucket
cat	cat
dog	dog
puppy	dog

sample output

Data	cat	dog
Cat is a domestic animal. Cat and dog are very beautiful.cat is friendly	3	1
Cat is a domestic animal. Cat and dog are very beautiful.dog is more friendly tan cat	3	2