Creating New Columns

[sravan_v007]

Hi All,

I am getting data from DB as below

Number	Role	Country	Name
1	Core	UK	Kumar
1	Core	US	Vennu
1	Non-Core	China	Pavan
1	Non-Core	UAE	Rohith
1	Register Owner	India	Sravan
2	Core	UK	Kumar
2	Non-Core	US	Vennu
2	Non-Core	China	Pavan
2	Register Owner	US	Rohith

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

Number	Role	Country	Name	Register Name	Register Country
1	Core	UK	Kumar	Sravan	India
1	Core	US	Vennu	Sravan	India
1	Non-Core	China	Pavan	Sravan	India
1	Non-Core	UAE	Rohith	Sravan	India
1	Register Owner	India	Sravan	Sravan	India
2	Core	UK	Kumar	Rohith	US
2	Non-Core	US	Vennu	Rohith	US
2	Non-Core	China	Pavan	Rohith	US
2	Register Owner	US	Rohith	Rohith	US

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

[tresesco]

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]

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.

[tresesco · Accepted solution]

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.