Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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