This content has been marked as final. Show 2 replies
In my test project i have a database and the database have two tables. I am fetching data using SQL Query and output as an InfoTable. I want to merge this InfoTable's side by side or top to the bottom . Tables may or may not have same columns. I have been trying to make this work around in few days. The document about "Getting To Know InfoTables" helps at some level but now i am stuck.
This is my structure.
getTableOne (SELECT id, name, phone FROM tableone) and TableOneDS (as DataShape)
getTableTwo (SELECT id, name, phone FROM tabletwo) and TableTwoDS (as DataShape)
So far i used CreateDatabaseFromDataShape snippets and CreateValue() but i havent figure it out how can i fetch this two infotables datas and put inside a loop and result will placed row by row.
Any suggestion will help.
Thank you !