Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can load data from string variable ?

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;

1 Solution

Accepted Solutions
Not applicable
Author

Instead [{d}] try ^(d)

View solution in original post

1 Reply
Not applicable
Author

Instead [{d}] try ^(d)