topic A Simple Scripting Question in QlikView

A Simple Scripting Question

Fri, 30 Apr 2010 08:36:39 GMT

Hi,

While loading the data from a file I have renamed certain fields into common names ( as AGENT_CODE as CODE). Now in case I further want to do some further modifications in the script with the renamed fields, do I need to use the original field name ( AGENT_CODE ) or can I use the new name ( CODE)?

Thanks for the help

AW:A Simple Scripting Question

Fri, 30 Apr 2010 08:48:10 GMT

Hello,

by using resident to load the fields or using load before load you have to use the new name (CODE).

The new name is given after finishing loading the table.

AW:A Simple Scripting Question

Fri, 30 Apr 2010 08:55:52 GMT

Sorry Martin - I could not quite get you

A Simple Scripting Question

prabhu0505 — Fri, 30 Apr 2010 09:24:35 GMT

I go with Martin, but I guess double 'as' is some typing mistake

( as AGENT_CODE as CODE)

AW:A Simple Scripting Question

Fri, 30 Apr 2010 09:25:51 GMT

Hi umang,

When u rename the orginal name to new name u should have to use new name.

eg:

AGENT_CODE AS CODE

use renamed field CODE as further change.

Regard's

Naren.

A Simple Scripting Question

Fri, 30 Apr 2010 09:58:18 GMT

Guys,

Maybe I could explain my problem. Below is my script

LOAD
AGENT_CODE as Code,
AGENT_NAME as Name,
AGENT_AGE as Age,
Code & Age as Unique
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1);

When I concatenate Code & Age, QV gives me an error but if i use AGENT_CODE and AGENT_AGE then the same works perfectly.

Is there some by which I can use Code & Age rather than the original names

A Simple Scripting Question

Fri, 30 Apr 2010 10:18:21 GMT

hi umang,

the point in your script is that when you rename AGENT_CODE as Code,AGENT_AGE as Age in the load statement,these fields (Code & Age) are not yet created ,they are still being created as newfields(Code & Age) in the load statement. while on the other hand, AGENT_CODE &AGENT_AGE are already there in the table ABC.xlsx from which u are loading these fields. so what u can do is this

tab1:

LOAD
AGENT_CODE as Code,
AGENT_NAME as Name,
AGENT_AGE as Age
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1);

tab2:

load Code&Age as Unique resident tab;

thanks

A Simple Scripting Question

Fri, 30 Apr 2010 10:31:38 GMT

Thanks tauqueer,

but in this case the two tbas would be seperate and would not be associated with each other right?

A Simple Scripting Question

Fri, 30 Apr 2010 10:36:46 GMT

I got it just need to do take a common field in the new tab and do a join to merge the two sets thanks

A Simple Scripting Question

Fri, 30 Apr 2010 10:36:55 GMT

hi umang,

u can do a left join

tab1:

LOAD
AGENT_CODE as Code,
AGENT_NAME as Name,
AGENT_AGE as Age
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1);

left join (tab1)load Code&Age as Unique resident tab;

thanks

A Simple Scripting Question

Fri, 30 Apr 2010 10:42:01 GMT

hi,

u can modify ur code like this

tab1:

LOAD
AGENT_CODE as Code,
AGENT_NAME as Name,
AGENT_AGE as Age
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1);

left join (tab1) load *,Code&Age as Unique resident tab;

including * will create a link

thanks

A Simple Scripting Question

Fri, 30 Apr 2010 13:19:13 GMT

After you changed your code, have you reloaded the file?