create new columns in loop and join to existing data

[Hilda]

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..

[binuacs]

@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

there can be more entries added to the lookup table. so depending on the buckets new columns has to be created

@binuacs

[gabrielvilella · Accepted solution]

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

[atcodedog05 · Accepted solution]

Hi @Hilda 

Here is how you can do it.

Workflow:

Hope this helps : )

[Hilda]

@gabrielvilella @atcodedog05 Thank you.!

[atcodedog05]

Happy to help : ) @Hilda 

Cheers and have a nice day!