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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading data in script editor issue.

HI,

I am loading data from Script Editor Like below.

AB1:

Load

a,

b,

c

from (Source);

The issue is ,my datamodel looks something like below:

AB1:

AB1.a

AB1.b

AB1.c

Where as I only want my table to have only column names instead of table name.column name.

Thank you for the help.

Thanks,

Alva.

11 Replies
maxgro
MVP
MVP

or post a small example of your csv file

h_prakash
Creator II
Creator II

Hi there,

I got the same issue but I was able to resolve by doing this. Hope this helps some one

 

Let vTableName = 'AB1';
For fieldIdx = 1 to NoOfFields('$(vTableName)')
LET vFieldname = FieldName($(fieldIdx), '$(vTableName)');
LET vFieldname1 = SubField(FieldName($(fieldIdx), '$(vTableName)'),'.',2);
RENAME Field [$(vFieldname)] TO [$(vFieldname1)];
Next fieldIdx

 

Thanks

Prakash