Query to implement

Question

Hi alteryx team,

I want to insert a value in another column based on values. there is example which i am giving.

"if mat_group=005 update mat_group_name="CARBON"

"if mat_group=006 update mat_group_name="CHEMICAL"

can any one suggest me how to update the value based on group given and which tool will update it. I try multi row formula tool. but i failed to get answer.

Get answer asap. that will be very helpful.

Thanks,

Kaustubh

atcodedog05 · Answer

Hi @Kaustubh17

If your data has a primary key what you can do is extract only the rows for which mat_group_name needs to be updated change it in the formula tool like above. Write it back using the output tool update option of db. This will update the data.

You can also explore in-db tools its similar to normal tools except it will execute the query on the SQL server.

https://community.alteryx.com/t5/Videos/In-Database-Workflows/td-p/330566

Hope this helps : )

Kaustubh17 · Answer

basically we want to update all the value which have 005 mate_group  change to mat_group name "carbon" that will we implemeted on single DB. all the value have 005 mat_group and we want the value which have 005, mat_group_name updated to carbon only .

atcodedog05 · Answer

Hi @Kaustubh17

I bit am confused can you please give more explanation about the usecase😅