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
    2 years 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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

In your Transform Sample file query, you can just click "Use Headers as First row (demote headers), then click Transpose, then click "Use First Row as Headers".  Now you have:

Now when you combine your table columnns, you'll have:

Now you can just click "Use Headers as First Row", click Transpose, then click "Use First Row as Headers", and you are done:

 

--Nate

Sohaib's avatar
Sohaib
Helper II
2 years ago

I have to get data source from folder not want to individually select table in my query. Your method work when we have two tables already loaded manually in transform query. Thanks for the help and input