topic Re: Why does renaming not work? in QlikView

Why does renaming not work?

Sun, 10 Nov 2013 18:15:40 GMT

"A as B" that should be the easy way to rename right???

So why does this not work:

LOAD Name1,

Name2,

Name3,

Name4 as NameA,

if(NameA <50, '<50', if(Name A <100, '<100', if(Name A <5000, '<5000'))) .... as Example,

Name5,

Name 6,

....

Without "...as NameA", that is just using Name4 works fine.

Re: Why does renaming not work?

rustyfishbones — Sun, 10 Nov 2013 18:20:27 GMT

Check the If Statement

You have spaces after the named field like Name A it should be NameA

Change it and let me know if it helps

Regards

Re: Why does renaming not work?

Sun, 10 Nov 2013 18:27:59 GMT

Hi,

You LOAD the field Name4 as NameA but the loaded field is still Name4 until you complete the LOAD statement.

So in the next statement you can't refer to NameA because the LOAD statement is not completed.

Only after the completion of the LOAD sratement you can refer to NameA.

What you may do is Name4 as NaneA and in the next line Name4 as NameB etc

Your if statement can only be used with the field Name4 (or any other field you are loading).

Regards,

Gerrit

Re: Why does renaming not work?

Sun, 10 Nov 2013 18:32:00 GMT

Nice spotted , but still it does not work. I just use these as examples as I use Danish words in my real script.

Re: Why does renaming not work?

rustyfishbones — Sun, 10 Nov 2013 18:34:17 GMT

Can you share an example Mikael?

Re: Why does renaming not work?

rustyfishbones — Sun, 10 Nov 2013 18:35:52 GMT

How did I miss that one!

Re: Why does renaming not work?

Sun, 10 Nov 2013 18:42:27 GMT

Thx, that answered my Q why it did not work.

So what is the solution? I tried to make a separate Load before this one:

LOAD Name4 as NameA

...

LOAD Name1,

Name2,

Name3,

NameA,

if(NameA <50, '<50', if(Name A <100, '<100', if(Name A <5000, '<5000'))) .... as Example,

Name5,

Name 6,

....

No luck with that, lol.

Re: Why does renaming not work?

israrkhan — Sun, 10 Nov 2013 18:42:29 GMT

Hi Mikael,

as Gerrit explian that Rename fields are not available untill load does not complete,

logically query executed like below:

From>> Where>> GroupBy >> Having clause >> Select>> OrderBy,

it mean you can use your rename fields in Orderby Clause, but not before that,,, so you should use real fields name not the renamed ones. like below:

LOAD Name1,

Name2,

Name3,

Name4 as NameA,

if(Name4 <50, '<50', if(Name4 <100, '<100', if(Name4 <5000, '<5000'))) .... as Example,

Name5,

Name 6,

..... and you can use field like Name A, either it should be Name_A or enclosed in brackets like [Name A]

Hope it helps..

Re: Why does renaming not work?

Sun, 10 Nov 2013 18:51:21 GMT

Sorry I cannot share the specific data, if that is what you mean.

Re: Why does renaming not work?

rustyfishbones — Sun, 10 Nov 2013 18:53:51 GMT

ok no problem, you have it sorted now so it's cool

Re: Why does renaming not work?

Sun, 10 Nov 2013 18:57:14 GMT

Super, but the point is, here I have only these 3 if statements, but I want to make like perhaps 20, and the original "Name4" is a bit long, of course I can copy it or change from the original source, but it would be cool to learn a trick to handle this in the future!

Re: Why does renaming not work?

Sun, 10 Nov 2013 19:58:06 GMT

Well still I did not find the solution I hoped for.

Re: Why does renaming not work?

Sun, 10 Nov 2013 20:27:50 GMT

I am not sure if this is what you are looking for but I tried to understand your problem.

assume the follwing example:

='<'&text(ceil(154/50)*50) returns '<200' (you may try it in a textbox)

If you make the function as: '<'&text(ceil(Name4/50)*50 you will always get the answer rounden 50 upward.

Don't know if it is what you are looking for, but it may save a lot of coding if it solves your problem .

Regards,

Gerrit

Re: Why does renaming not work?

Sun, 10 Nov 2013 20:45:03 GMT

Well I got the idea of if function here: Company and number aligned, and employee intervals

The case is that originally it is just a very long name to write in the code every and to read by the way, so I just hoped for a quick fix to shorten the name field, without messing with the original source.

Re: Why does renaming not work?

Sun, 10 Nov 2013 21:03:53 GMT

If it is about the renaming of the field where you want a trick for, that is simple.

1 Load the table where you can rename the field.

2 Load the table as resident and their is your renamed field that you can use as you like,

3. Drop the original table.

Regards,

Gerrit

Re: Why does renaming not work?

Sun, 10 Nov 2013 21:14:04 GMT

That's the case , and that is what I though I could do in my answer earlier "Nov 10, 2013 1:42 PM".

"as resident"? - Could you plz explain to me how to do this, perhaps a little code example?

Re: Why does renaming not work?

Sun, 10 Nov 2013 21:31:43 GMT

Myfile:

LOAD

Name1,

Name2,

Name3,

Name4 as NameA,

Name 5

From xxxxxxxxxxx;

Newfile:

LOAD

Name1,

Name2,

Name3,

NameA,

Name 5

Resident Myfile;

Drop table Myfile;

resident is used if data should be loaded from a previously loaded table.

Regards,

Gerrit

Re: Why does renaming not work?

israrkhan — Mon, 11 Nov 2013 07:01:04 GMT

Hi Mikael,

1) first load whole data from table, and in the load just Rename your fields.

2) then load a Resident load, and in resident load you can write your if statements, and the drop the first table, you will have a new table..

if you are not aware with resident load, let me know, i will write here with example...

Re: Why does renaming not work?

Mon, 11 Nov 2013 17:37:30 GMT

Super, it seems to work 🙂

Though it did not like the "Dtop table", false statement, what does it do?

Re: Why does renaming not work?

swuehl — Mon, 11 Nov 2013 17:45:48 GMT

-Mikael- wrote:

Thx, that answered my Q why it did not work.

So what is the solution? I tried to make a separate Load before this one:

LOAD Name4 as NameA

...

LOAD Name1,

     Name2,

     Name3,

     NameA,

     if(NameA <50, '<50', if(Name A <100, '<100', if(Name A <5000, '<5000'))) .... as Example,

     Name5,

     Name 6,

     ....

....

No luck with that, lol.

I don't think you need a second load here.

Why does this not work for you:

LOAD Name1,

Name2,

Name3,

Name4 as NameA,

if(Name4 <50, '<50', if(Name4 <100, '<100', if(Name4 <5000, '<5000'))) .... as Example,

Name5,

Name 6,

....

FROM YourSource;

You can only use fields from your input table in your statements (Name1 to Name6) left from as , except when using the peek() function.

edit: Missed an answer below the one I replied to, but if you want to first rename, then calculate, you can still do a preceding load:

LOAD *,

if(NameA <50, '<50', if(NameA <100, '<100', if(NameA <5000, '<5000'))) .... as Example;

LOAD Name1,

Name2,

Name3,

Name4 as NameA,

Name5,

Name 6,

....

FROM YourSource;