topic Re: Rename filed names in same table in QlikView

Rename filed names in same table

priya945 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one Table with two columns as below

Test
ColumnA	ColumnB
A	D
B	E
C	F

Loading in QV script as

Test:

Load

ColumnA

ColumnB

From Test;

Requirement is to have single columnA with all the values from both columns as below. Please suggest

ColumnA

Re: Rename filed names in same table

micheledenardi — Thu, 25 Oct 2018 06:28:44 GMT

Test:
Load
    ColumnA
From Test;


Concatenate(Test)
Load
    ColumnB as ColumnA
From Test;

Re: Rename filed names in same table

priya945 — Thu, 25 Oct 2018 07:37:58 GMT

Thank you Michele for your quick reply.

I am making changes in a data models that is already built so using above method id disturbing the data Model so please any other method where I can rename my field name

Re: Rename filed names in same table

shiveshsingh — Thu, 25 Oct 2018 07:47:24 GMT

Are these fields associated with the model? What is the key?

You can left your model as it is and create one separate table with concatenated columns as suggested.

Re: Rename filed names in same table

priya945 — Fri, 26 Oct 2018 03:04:30 GMT

Hi Shivesh,

Please find my data and please suggest how to rename Region as Sub-continent or copy Region values to Sub-continent

Test:
LOAD * Inline [
Product, Sales ,Continent, Sub-continent, Region
A, 1, APAC, India, SriLanka
B, 2, Europe, UK , Ireland
C, 3, Australia, Aus, Aus
];

Test:

Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Sub-continent,
Region
From Test;

Re: Rename filed names in same table

andrey_krylov — Fri, 26 Oct 2018 04:19:03 GMT

Hi Priya. Maybe this

Test:

LOAD * Inline [
Product, Sales ,Continent, Sub-continent, Region
A, 1, APAC, India, SriLanka
B, 2, Europe, UK , Ireland
C, 3, Australia, Aus, Aus
];

Outer join(Test)

Load Product, Sales ,Continent, Region as [Sub-continent]

Resident Test; Drop Field Region from Test;

Re: Rename filed names in same table

jyothish8807 — Fri, 26 Oct 2018 04:50:00 GMT

May be like this also: Not sure what you are trying to achieve:

Test:
LOAD * Inline [
Product, Sales ,Continent, Sub-continent, Region
A, 1, APAC, India, SriLanka
B, 2, Europe, UK , Ireland
C, 3, Australia, Aus, Aus
];

Noconcatenate

Test1:

Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Sub-continent
From Test;

concatenate

Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Region as Sub-continent
From Test;

Drop Table Test;

Br,

Re: Rename filed names in same table

priya945 — Fri, 26 Oct 2018 06:35:21 GMT

Hi KC,

Thank you for your suggestion but with your method(Concatenation) some of the values are getting double

Please suggest any alterative if possible

Regards,

Priya

Re: Rename filed names in same table

jyothish8807 — Fri, 26 Oct 2018 06:43:54 GMT

I am still not clear what do you mean by "rename Region as Sub-continent or copy Region values to Sub-continent"

While doing like this, either region values will be overwritten by Sub-continent values or vice versa.

Can you please share your expected output.

Br,

Re: Rename filed names in same table

shiveshsingh — Fri, 26 Oct 2018 07:34:09 GMT

So you need Region and Sub continent column with same values?

Re: Rename filed names in same table

Anil_Babu_Samineni — Fri, 26 Oct 2018 09:26:24 GMT

Can you post or clarify your expected result, Instead simple Table? that would help

Re: Rename filed names in same table

priya945 — Fri, 26 Oct 2018 12:19:35 GMT

Hi Anil,

Thanks for your response, please find below data and my requirement

Fact1
Product	Sales	Continent	Sub-continent
A	3	APAC	India
E	5	APAC	India
B	2	Europe	UK
C	7	Australia	Aus
D	8	Ameicas	USA

Fact2
Product	Sales	Continent	Sub-continent	Region
A	1	APAC	India	Bengaluru
E	2	APAC	India	Hyd
B	2	Europe	UK	Ireland
C	3	Australia	Aus	Aus
D	5	Ameicas	USA	USA

Two Fact table, I am concatenating as below with keys to dimension tables

Fact1:
Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Sub-continent
From Fact1;

Concatenate(Fact1)
Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Sub-continent,
Region
From Fact2;

Requirement: How to handle Region field so that I can show the all Region field values in Sub-continent field as below

Sub-continent

India

Aus

USA

Bengaluru

Hyd

Re: Rename filed names in same table

vishsaggi — Fri, 26 Oct 2018 13:13:31 GMT

Are you looking for this?

You create those key fields in the below load tables.

IF yes, you can try like

Fact1:

LOAD * INLINE [

Product, Sales, Continent, Sub-continent

A, 3, APAC, India

E, 5, APAC, India

B, 2, Europe, UK

C, 7, Australia, Aus

D, 8, Ameicas,USA

];

Fact2:

LOAD * INLINE [

Product, Sales, Continent,Sub-continent

A, 1, APAC, India

E, 2, APAC, India

B, 2, Europe, UK

C, 3, Australia, Aus

D, 5, Ameicas, USA

];

RegionFact:

LOAD * INLINE [

Product, Sales, Continent, Sub-continent

A, 1, APAC, Bengaluru

E, 2, APAC, Hyd

B, 2, Europe, Ireland

C, 3, Australia, Aus

D, 5, Ameicas, USA

];

Re: Rename filed names in same table

priya945 — Fri, 26 Oct 2018 13:17:54 GMT

Hi Vishwa,

Thanks for reply but you are missing Region field from my data. Please use my data and provide me some solution if possible

Re: Rename filed names in same table

vinod22kv — Fri, 26 Oct 2018 13:20:03 GMT

Do the above script in new qvw and store this in to qvd and call that qvd in your final qvw.

Thanks and Regards,

Vinod.

Re: Rename filed names in same table

vishsaggi — Fri, 26 Oct 2018 14:04:57 GMT

Sorry i mean the third table where you see sub-continent i have renamed the region to sub-continent. Ok can you tell me what is your expected output with field names and values can you provide us.

Re: Rename filed names in same table

jensmunnichs — Fri, 26 Oct 2018 14:23:14 GMT

I'm pretty confused. Is it that you want [Sub continent] and [Region] to be displayed in a single listbox to make selections from? Or do you need [Region] to replace [Sub continent] in script if the field exists?

Re: Rename filed names in same table

priya945 — Fri, 26 Oct 2018 14:36:21 GMT

Expected out Concatenated Fact Table where Region field value are now in Sub-continent field

Fact1
Product	Sales	Continent	Sub-continent
A	3	APAC	India
E	5	APAC	India
B	2	Europe	UK
C	7	Australia	Aus
D	8	Ameicas	USA
A	1	APAC	Bengaluru
E	2	APAC	Hyd
B	2	Europe	Ireland
C	3	Australia	Aus
D	5	Ameicas	USA

Re: Rename filed names in same table

jensmunnichs — Mon, 29 Oct 2018 07:17:18 GMT

I think if you just change this

Concatenate(Fact1)
Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Sub-continent,
Region
From Fact2;

To this

Concatenate(Fact1)
Load
AutoNumberHash128(Product) as %Product_Key,
AutoNumberHash128((Continent),(Sub-continent)) as %Con_Key,
Product,
Sales,
Continent,
Sub-continent,
Region as Sub-continent
From Fact2;

You should have what you want. This completely drops the original Sub-continent field in the second fact table and replaces it with the region field.

Re: Rename filed names in same table

satishqlik — Mon, 29 Oct 2018 09:43:23 GMT

Hi,

May be something like this??

Thanks,