How to convert Multiple Fields as a single Field

[SatyaPaleti]

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 

[stevedark]

Hi @SatyaPaleti 

Please see my response over on this thread:
https://community.qlik.com/t5/App-Development/How-to-convert-Multiple-fields-in-to-Single-field-dyna...

Steve