Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combine tablets

Hi all,   I hope you are able to help me.   I have got one big folder and in this folder I get two different data types - CSV and JSON. I build up my data tables for CSV and JSON.    CSV table...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    For your case, you should keep the name of the column headers to be the same for the two tables, then you could use Append queries.

     

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

You can use the Append Queries feature, or Table.Combine function if you know M

 

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Please try below steps:

 

Step1 : Convert your JSON format file into Table structure in "Power Query" after importing your JSON file.

 

 

Step2: Then expand the table with all the fields as required. 

 

 

Now you have JSON file in table structure as below

 

 

Then you can use "Append Queries" to append both JSON file and Table into single final result which can be used further.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    thanks for the fast reply.

     

    If I use "Append Queries" I got this (arrows show my prefer solution).

     

     

    BR