topic Re: Creating New Columns in App Development

Creating New Columns

sravan_v007 — Fri, 03 Sep 2021 05:21:37 GMT

Hi All,

I am getting data from DB as below

From above data i have to derive new fields and values for those fields are based on Role = 'Register Owner' like below

I need to archive this in Qlik Sense Backend. Appreciate your help.

tresB — Fri, 03 Sep 2021 05:36:25 GMT

One solution could be like:

t1:
LOAD Number,
Role,
Country,
Name
FROM
[https://community.qlik.com/t5/App-Development/Creating-New-Columns/td-p/1833445]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);

Join
Load
Number,
Name as [Register Name],
Country as [Register Country]
Resident t1 where Role='Register Owner';

sravan_v007 — Fri, 03 Sep 2021 06:17:11 GMT

Hi.. Thanks for the replay..

But, this will be a cross join and my data set is huge... I am worried it never gets refreshed.

tresB — Fri, 03 Sep 2021 06:31:49 GMT

This will not be a cross join. To remove confusion you can replace join with inner/left join. In the above script, Number is your key field.