Forum Discussion

bigrig33's avatar
bigrig33
New Member
2 years ago

5000 Rows of Data with duplicate data

Apologies if something similar has been posted.    I have a table with 5281 rows of data. I have taken screenshot, data hid as priviliged. so the first two rows are the same person and he did two t...
General Comment
Need Help
Show and Tell
Tips and Tricks
mussaenda's avatar
mussaenda
Community Champion
2 years ago

Please provide a sample data that we can copy to provide with a solution

bigrig33's avatar
bigrig33
New Member
2 years ago

Hi mussaenda 

So I had to edit data as some sensitive, but you will get the jist. I have multipe entries of similar data based over 5200 rows, I want just one row per entry per payno but i want all the data to follow, so lets take the first two lines, can I have one entry for those two lines,but both training entries and also start dates on the same line. 

 

 

  • mussaenda's avatar
    mussaenda
    Community Champion
    2 years ago

    Hi bigrig33 ,


    you can do like this to have one entry


    or you can do like this

     

    or you can do like this and create a star schema

     

    other than those, i hope others will meet your requirements.

    Hope this helps