Multiple Dimension In to Single Dimesion

[Satish]

Hello Qlik Expert,

I My Data Set I have 2 Dimesion As Region And City.

I have to Display New Dimesion As Region Followed By City.

Input:

Region

City

Output:

Region

City

I have Uploaded the Input data and Output Data In Excel File.

Thanx In Advance..!!!

[Akshesh_Patel]

hi ,

//something like : 

Table1:
Load
City as Output

FROM [lib://Sample/community.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Sheet1);

Load
Region as Output

FROM [lib://Sample/community.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Sheet1);

Regards,

Akshesh