Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

QUALIFY

Hello,

Is there other method to replace QUALIFY ?

For exemple: I want to have two separate tables as following T1, T2,

but I can't creat a zone table or a simple table only with the table T1, it will be like figure[3].

Currently, I use QUALIFY to solve this problem, but evey time I have to enter as "T1.ID", " T1.Titre", ....

if I want to do the same thing for table T2, I have to do still a time the same thing with "T2.ID", .....

So I want to know if there are some betters methods.


thank you very much.

T1:

load * INLINE [                                                                        

ID, Titre

1, Lion

2, Léon

3, Flower

4, Dark

]

;

T2:

NoConcatenate

load * INLINE [

ID, Titre

1, Lion

2, Léon

3, Flowers

4, Darck

5, Lion

]

;

figure[3]

10 Replies
IAMDV
Honored Contributor II

Re: QUALIFY

I much prefer using Mapping Load for renaming the fields. Which contains existing names and new names.

Re: QUALIFY

Hi,

I did not understand want you wanted , Qualify is to make every column as unique and it s working as it meant for!!

can you please elaborate

Not applicable

Re: QUALIFY

Is there another way to that?

because with this method, evey time, we have to begine with the table name, for exemple T1.ID, I have write T1.

when I have many expressions, that's not convienient.

qlikview2015
Contributor

Re: QUALIFY

Hi !

Use

UNQUALIFY*;

at the end of the Script, or i did not understand the question !?

Berst regards

Mike Preuss

Re: QUALIFY

Ya, I got your point but we don't have other choice , else you need to do alias using the as statement and need to give the desired names, apart from this we don't have a alternative .

Not applicable

Re: QUALIFY

Ok, thank you anyway.

Re: QUALIFY

can you please close this thread !!

Re: QUALIFY

You don't have to qualify the first table. As far as I understand you, it can keep it's original column names.

The second table can be loaded as follows:

T2:

NoConcatenate

load ID as ID2, Titre as Titre2 INLINE [

ID, Titre

:

This may be simpler than specifying table prefixes for all fields, but you'll have to make sure that the correct associative links are still being made.

Peter

MVP
MVP

Re: QUALIFY

i would concatenate the two tables, and add a source field to identify the source:

T1:

load *,  'T1' As Source

INLINE [                                                                       

ID, Titre

1, Lion

2, Léon

3, Flower

4, Dark

]

;

Concatenate(T1)

load *,  'T2' As Source

INLINE [

ID, Titre

1, Lion

2, Léon

3, Flowers

4, Darck

5, Lion

]

;

Now use a set expression like {<Source = {'T1'}>} to select only from the T1 source.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser