Create Multiple new Columns by comparing two columns values

[Hariz]

I am new to qliksense and trying to find a way to create multiple new column by comparing two column values(Id1 and Id2) and writing to the parent 

Input

Game	City	Id1	Id2	Viewers	Ratings
Baseball	New York	11		1000	10
Baseball US	San Francisco		11		8
Baseball Germany	Berlin		11		6
Baseball England	London		11		7
Football	New York	22		2000	10
Football Brazil	Porto		22		8
Football France	Paris		22		5

Output

Game	Id1	Game1	City1	Game2	City2	Game3	City3	Viewers	Ratings
Baseball	11	Baseball US	San Francisco	Baseball Germany	Berlin	Baseball England	London	1000	10
Football	22	Football Brazil	Porto	Football France	Paris			2000	10

[Hariz]

Any help on the above query