topic Loading data in script editor issue. in QlikView

Loading data in script editor issue.

Mon, 18 Jan 2016 18:14:41 GMT

HI,

I am loading data from Script Editor Like below.

AB1:

Load

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.

Re: Loading data in script editor issue.

sunny_talwar — Mon, 18 Jan 2016 18:57:00 GMT

You might have a qualify statement before you load the table

QUALIFY *;

You need to comment it out and it should fix the issue for you.

Re: Loading data in script editor issue.

Mon, 18 Jan 2016 18:58:56 GMT

No,I dont have any qualify statement...is there any setting in the document that I have to change ?

Re: Loading data in script editor issue.

sunny_talwar — Mon, 18 Jan 2016 19:08:34 GMT

Can you share the complete script? Make sure that there is not hidden script?

Re: Loading data in script editor issue.

maxgro — Mon, 18 Jan 2016 19:10:57 GMT

does your data come from a .qvd file?

you can rename the fields

AB1:

load

AB1.a as a,

AB1.b as b,

AB1.c as c

from

....

Re: Loading data in script editor issue.

Mon, 18 Jan 2016 19:13:15 GMT

No..it is coming from the .csv file directly.

Re: Loading data in script editor issue.

jonathandienst — Tue, 19 Jan 2016 06:43:08 GMT

Well you can still rename the fields as maxgro suggested.

Re: Loading data in script editor issue.

t_chetirbok — Tue, 19 Jan 2016 06:55:30 GMT

So, if you are sure that there is not QUALIFY, you can write UNQUALIFY *; before load. Maybe it'll help.

Re: Loading data in script editor issue.

jonathandienst — Tue, 19 Jan 2016 06:59:07 GMT

UNQUALIFY will reverse a QUALIFy statement. It will not remove the table prefix if it is coming like that from the csv source file.

Re: Loading data in script editor issue.

t_chetirbok — Tue, 19 Jan 2016 07:03:50 GMT

I think fileds in csv name like a,b,c and after load fields start name with prefix AB1.

Pavana.alvashetty‌, is'nt it?

Re: Loading data in script editor issue.

maxgro — Tue, 19 Jan 2016 18:08:28 GMT

or post a small example of your csv file

Re: Loading data in script editor issue.

h_prakash — Wed, 03 Aug 2022 01:07:06 GMT

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