Forum Discussion

Powerbiuser77's avatar
Powerbiuser77
Frequent Visitor
7 years ago

Append and merge tables in R How?

Hi,   I have on a server PDF-documents. I upload them one by one from my desktop in Power Bi under New Source to power query. For every single PDF-document I get three tables. My intention: Step...
Need Help
  • Powerbiuser77's avatar
    Powerbiuser77
    Frequent Visitor
    7 years ago

    Hi Frank,

    I do not want to merge visuals. Step 1 and 2 are tables that I extract from PDF documents. I want to append and merge tables in R script.

     

    The example in the link shows that it is possible to merge tables with R-script.

     
    Primarily I want to realize Step 2 and 3 together in an R code
     
    Thanks for your support

     

    • Powerbiuser77's avatar
      Powerbiuser77
      Frequent Visitor
      7 years ago

      Hallo everybody,

       

      with the help of this link I have solved step 2 and 3. 
       
      For step 2 I used the following R code:
      cbind(df1, df2)
       
      and for step 3, I have used the following R code:
      rbind(df1, df2)
       
      Can anyone confirm that everything was right up to here.
       
      My main goal is to continue to do steps 1 through 3 in a R code.
       
      Can someone help?