Hi Everyone,
I have following requirement could some one help me to resolve this issue
we are having n no of tables. we have to load all the fields of all the tables and assign it to one field.
Here is the example
NoConcatenate
Demo_Table:
Load
'' as Demo ID
AutoGenerate(0);
Tables:
load
Demo_Tables_test
from xyz.qvd
FOR i=0 to NoOfRows('Tables')
let vTableName= Peek('Demo_Tables_test ',$(i));
$(vTableName):
LOAD
*
;
Select
*
FROM $(schema).$(vTableName);
Concatenate(Demo_Table)
Final_Tabel
Load *
Resident $(vTableName);
Now all the fields of all tables were coming in to Demo_Table.
All these fields should assign to a single field. For example Field name Dimension. If the user see Dimension then all the values should appear
Can some one help me to achieve this
Thanks,
Satya
