Can load data from string variable ?

Mon, 21 Nov 2011 12:41:55 GMT

I have script . What wrong in here ?

TableOfHierarcy:

hierarchy (ID, ParentID, Name, 'ParentName', Name, 'Path', '|', 'Depth')

load
     ID,
     ParentID,
     Nameresident TableOfNodes;

LET a = NoOfFields('TableOfHierarcy');

LET b = 1;

LET c = '';

LET d = '';

for b = 1 to a-6
c = c & ' name' & $(b) & ' as new_name' & $(b) &' ,'
NEXT

d = left(c,len(c)-1);

TableOfHierarcy2:

load
     ID,
     ParentID,
     Name,
     ParentName,
     Path,

     [{d}],

     Depth

resident TableOfHierarcy;

Mon, 21 Nov 2011 13:29:35 GMT

Instead [{d}] try ^(d)

topic Can load data from string variable ? in QlikView