topic Dynamic Naming in Qlik NPrinting

Dynamic Naming

Anonymous — Tue, 04 Apr 2017 05:18:18 GMT

I have one table which fields name should be change as per the MASTER_Temp TABLE

TEMP:
LOAD * Inline [
Temp_1,Temp_2
A,X
B,Y
C,Z ];

MASTER_Temp:
LOAD * INLINE [
Group, Name
Temp_1, Region
Temp_2, SubRegion
];

But in our scenario we need to create some different level which a calculated fields i.e. Region Level_1, Region Level 2 and its name should be change dynamically

Even though I have created the logic for the same,But I just want to know ,Is there is any other better method i.e. by loop or something else

Please find the attachment of the application of better understanding.

Re: Dynamic Naming

Anonymous — Tue, 18 Apr 2017 10:10:33 GMT

any update

Re: Dynamic Naming

Chanty4u — Tue, 18 Apr 2017 10:34:13 GMT

i think in NP designer you can create dynamic names? correct me if i am wrong.

Re: Dynamic Naming

Lech_Miszkiewicz — Wed, 19 Apr 2017 01:27:33 GMT

Hi Shweta,

I looked at it and i dont understand what you are trying to achieve.

i only assume you change values from column Group to Group Level 1 If it is Temp1, then Group Level 2 if it is Temp2.

You wrote a MASTER table code, but what is a puprose of it? I would use mapping table in DB or XLS to map values instead.

Can you present us with what are you trying to avchieve? From--> To?

That would help me understand. Your current code is just a hardcoded conversion, in my opinion is not a dynamic solution.

regards

Lech

Re: Dynamic Naming

Lech_Miszkiewicz — Fri, 23 Jun 2017 05:03:13 GMT

Is this really a correct answer?