HI,
Can we put all the dimensions of a heirarchy in one column ???
Please help ...
Thanks in advance
Actaul DATA
|
---|
India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Ahemadabad[Territory] | India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Anand[Territory] | India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Jamnagar[Territory] | India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Junagarh[Territory] | India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Mehsana[Territory] | India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Rajkot[Territory] | India | North East Zone | Ahmedabad Region | Baroda Dist | Baroda[Territory] | India | North East Zone | Ahmedabad Region | Baroda Dist | Bhavnagar[Territory] | India | North East Zone | Ahmedabad Region | Baroda Dist | Navsari[Territory] | India | North East Zone | Ahmedabad Region | Baroda Dist | Surat[Territory] | India | North East Zone | Ahmedabad Region | Jaipur-Dist | Bikaner[Territory] | India | North East Zone | Ahmedabad Region | Jaipur-Dist | Jaipur[Territory] | India | North East Zone | Ahmedabad Region | Jaipur-Dist | Jodhpur[Territory] | India | North East Zone | Ahmedabad Region | Jaipur-Dist | Kota[Territory] | India | North East Zone | Ahmedabad Region | Jaipur-Dist | Kota[Territory] | India | North East Zone | Ahmedabad Region | Jaipur-Dist | Udaipur[Territory] | India | North East Zone | AP Region | Aurangabad Dist | Agartala[Territories] | India | North East Zone | AP Region | Aurangabad Dist | Ahemadabad[Territory] | India | North East Zone | Delhi Region | Calicut Dist | Ahemadabad[Territory] | India | North East Zone | Delhi Region | Calicut Dist | Dehradun Pool[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Amritsar[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Bhatinda[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Chandigarh[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Faridabad[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Gurgaon[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Karnal[Territory] | India | North East Zone | Delhi Region | Chandigarh-Dist | Ludhiana[Territory] |
|
QlikView Output
|
---|
India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Ahemadabad[Territory] | Anand[Territory] | Jamnagar[Territory] | Junagarh[Territory] | Mehsana[Territory] | Rajkot[Territory] | Baroda Dist | Baroda[Territory] | Bhavnagar[Territory] | Navsari[Territory] | Surat[Territory] | Jaipur-Dist | Bikaner[Territory] | Jaipur[Territory] | Jodhpur[Territory] | Kota[Territory] | Kota[Territory] | Udaipur[Territory] | AP Region | Aurangabad Dist | Agartala[Territories] | Ahemadabad[Territory] | Delhi Region | Calicut Dist | Ahemadabad[Territory] | Dehradun Pool[Territory] | Chandigarh-Dist | Amritsar[Territory] | Bhatinda[Territory] | Chandigarh[Territory] | Faridabad[Territory] | Gurgaon[Territory] | Karnal[Territory] | Ludhiana[Territory] |
|
Requirement |
---|
India | North East Zone | Ahmedabad Region | Ahmedabad Dist | Ahemadabad[Territory] | Anand[Territory] | Jamnagar[Territory] | Junagarh[Territory] | Mehsana[Territory] | Rajkot[Territory] | Baroda Dist | Baroda[Territory] | Bhavnagar[Territory] | Navsari[Territory] | Surat[Territory] | Jaipur-Dist | Bikaner[Territory] | Jaipur[Territory] | Jodhpur[Territory] | Kota[Territory] | Kota[Territory] | Udaipur[Territory] | AP Region | Aurangabad Dist | Agartala[Territories] | Ahemadabad[Territory] | Delhi Region | Calicut Dist | Ahemadabad[Territory] | Dehradun Pool[Territory] | Chandigarh-Dist | Amritsar[Territory] | Bhatinda[Territory] | Chandigarh[Territory] | Faridabad[Territory] | Gurgaon[Territory] | Karnal[Territory] | Ludhiana[Territory] |
|
Hi first table is the actual Data, then what I am getting after using pivot table in qlikview, last one is my requirement. Also I have attached the same as excel.
Please help..