Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Flatten dimension table

 

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

Need Help

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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