Flatten dimension table

[Anonymous]

Hi All,

I have this below table ,Level 1, level 2 and level 3 have only one value repeated. rest all levels have different data .

Can you please help me to flatten this table

ID	ID___T	Level1	level2	level3	level4	level5	level6	level7
1	ABC	IG	IG Russia (IGR)	IG Russia	SEIC Corporate	SEIC Corporate	SEIC Corporate	SEIC Corporate
2	CDE	IG	IG Russia (IGR)	IG Russia	SEIC	Sakhalin Pipelines	Sovetskoye Pipelines	Gas Transfer Terminal Dalnee
3	EFG	IG	IG Russia (IGR)	IG Russia	SEIC	Sakhalin Pipelines	Sovetskoye Pipelines	PMD Sovetskoye

I have tried creating index by taking all columns into consideration however this does not help if i have huge data

Regards,

Husna

[Anonymous]

Hi @Pragati11 ,

The data which you can see is the heirarchical data used in my hierarchiral visual.

The data is very big like 10 lakh rows ...Can you provide some insight on how to reduce the size 

[Pragati11]

Hi @Anonymous ,

I am still struggling to understand what you are trying to achieve here. 
I understand that you are trying to identify rows as Unique rows using the index column, but I don't understand the part what is not working.

Can you explain more? 

Thanks,

Pragati