AMPscript Exercise AMP-E03a - Lookups & LOOPs 1

[@giovane___8507]

Congrats Cameron! It's an amazing initiative! Super helpful!

[@anshumanmishra7575]

Hi Giovane, could you understand the logic in which @beams is being populated? It is not storing value from any DE nor through any function. Same with @points.

[@ravidubey122]

Awesome, learned a lot. Thank you

[@srilakshmi4508]

Awesome Cam.. thanks a lot

[@TechloverSam]

I am getting an error "failed to convert parameter value from a string to a int32." after running first loop. 03:48

[@CameronRobert]

What section of the code are you up to? If you get stuck, try following the code exactly as seen in the video, or check the last pages of the Exercise document for copies of the code answers.

[@TechloverSam]

​@@CameronRobert Its is working now! Thanks.😃🙌 I have a question for you! I want to insert the same data in one column. For example: The column name "Account_Id" should have the value "20" for all rows and update/upsert the DE also. How can I achieve this using AMPscript or SS.JS? Please help!

[@stevenduong8126]

Could you please advise the tool you used to draw the diagram relationship? Thanks.

[@CameronRobert]

Dbdiagram.io, it’s a great tool!

[@stevenduong8126]

@@CameronRobert Thanks so much, Sir.