Forum Discussion

Sohaib's avatar
Sohaib
Helper II
2 years ago
Solved

Need column in respective arrangement

I have 2 tables data table 1 name is "1.csv" and table 2 name is "2.csv". Both table have common column named "Site" and have same value/text but when i combined both through append and merge there a...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    As the number of tables are not clear, i recomend you follwo this step.
    fits append the tables to reach the result like the next image

     

     

     

     

     

    right click on column site and use unpivot other columns to reach the next result

     

     

     

    then select Attribute column and go to transform tab and pick Pivot column command.
    like the below image pic value for value column.

     

    hit ok to reach your result as below.

     

     



    I hope this help you, if you have any other question, pls do not hesitate and ask

Omid_Motamedise's avatar
Omid_Motamedise
Super User
2 years ago

You need to use the merge command instead of appending, If you have used Merge, what was the problem?

Sohaib's avatar
Sohaib
Helper II
2 years ago

Because my source is folder not single files. Means I need to combine all the files in the folder automatically and all the data of uncommon column arrange with respect to common column