Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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