i was trying a lot since a couple of days to combine and i was getting errors, until i watched your video and my problem solved.. you helped me., thx. but if i add new column on one of the main tables, i can't see data comes into the querytable
Hello, Thank you for this it is very helpful ! However, I have tried this with csv files and I keep getting this error "DataFormat.Error : the external table is not in the expected format" Could someone help ? I am able to do a query individually but not alltogether like in the video.
i have 5 excel workbooks with all the sheets named the same. what I want to do is combine the 5 excel files into one workbook with the sheets in each of the excel file file merged together with the same sheet name respectively. for example in excel file 1 there are sheet names sales and items and in excel file 2 there is also sheet names sales and items. what I want to do is combine the two excel files with each other so that excel file 1 sales and excel file 2 sales are merged together and excel file 1 and excel file 2 items are merged together. Is there a way for this? And I want the excel file to be updated on a regular basis maybe weekly once or twice if there are any changes into the 5 excel files I do not want to put them all in one destination file. I want to keep the 5 excel files as it is but combine them as one excel file where it gets updated frequently if there are any changes into the 5 excel workbooks
I have to combine data from multiple worksheets to a single worksheet. But my data have 1605 columns. When I bringing the data it only imports only 256 columns. What is the solution to bring all 1605 columns.
Liked, shared, and followed along with my own workbooks. Thank you for the video.
Super sir, you are on track after long time.....wishes for many videos.
Very nice! Thanks for the tips. Thumbs up!!
Perect. Thanks for sharing and look forward to more videos from you.👍
great content!
Awesome videos!
i was trying a lot since a couple of days to combine and i was getting errors, until i watched your video and my problem solved.. you helped me., thx. but if i add new column on one of the main tables, i can't see data comes into the querytable
Will it work in the CSV file format..?
excellent great job
How to make these steps nested so that query to be lightning fast? Can we filter before expanding tables?
Not sure if you will benefit from nesting filter arguments before expanding all the tables, since Excel does not support query folding.
Hello,
Thank you for this it is very helpful !
However, I have tried this with csv files and I keep getting this error "DataFormat.Error : the external table is not in the expected format"
Could someone help ?
I am able to do a query individually but not alltogether like in the video.
i have 5 excel workbooks with all the sheets named the same. what I want to do is combine the 5 excel files into one workbook with the sheets in each of the excel file file merged together with the same sheet name respectively. for example in excel file 1 there are sheet names sales and items and in excel file 2 there is also sheet names sales and items. what I want to do is combine the two excel files with each other so that excel file 1 sales and excel file 2 sales are merged together and excel file 1 and excel file 2 items are merged together. Is there a way for this? And I want the excel file to be updated on a regular basis maybe weekly once or twice if there are any changes into the 5 excel files I do not want to put them all in one destination file. I want to keep the 5 excel files as it is but combine them as one excel file where it gets updated frequently if there are any changes into the 5 excel workbooks
I have to combine data from multiple worksheets to a single worksheet. But my data have 1605 columns. When I bringing the data it only imports only 256 columns. What is the solution to bring all 1605 columns.