@Nived_Nambiar
This approach is truly impressive, and I wasn't aware that merging could be done this way. So, thank you for sharing that.
I tested it with three rows of values across all three DataTables, but the merging doesn't seem to work correctly. Interestingly, it works perfectly when there's only a single row in each DataTable.
Below is the code:
SET dataTable1 TO { ^['Name', 'Phone', 'State'], ['Alice', '1234', 'AA'], ['Bob', '2345', 'BB'], ['Cindy', '3456', 'CC'] }
SET dataTable2 TO { ^['Name', 'Phone', 'State'], ['David', '4567', 'DD'], ['Eva', '5678', 'EE'], ['Frank', '6789', 'FF'] }
SET dataTable3 TO { ^['Name', 'Phone', 'State'], ['Grace', '7890', 'GG'], ['Henry', '8901', 'HH'], ['Ivy', '9012', 'II'] }
SET dataTableFinal TO dataTable1 + dataTable2 + dataTable3
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
