Hi! I want to extract data from 2 different sheets from 1 excel file, and I want to build 2 different data tables (one per sheet). As you can see in the image, I already tried to do this but I always have the same error in the assign “the origin doesn’t contains data rows”, so I think my Data Tables…

@Andre_Almeida If there are only 1 columns on both side there is no need of join operation, as you just want to exclude the rows which is equal on the Other Sheet. I have made an Except Operation, which I believe is the Operation you need. If this is not what you wanted please explain in detail the …

Extract data from excel sheet to build a datatable

Learning Hub

Andre_Almeida (André Almeida) May 18, 2020, 9:14am 6

I have seen this in the topic above

Topic		Replies	Views
Create datatable 2 tables in 1 sheet Help	1	1023	August 21, 2018
Comapre data to an excel sheet Studio studio , question , project_panel	6	37	November 11, 2024
I want to extract certain columns only in my new data table Learning Hub studio	5	2613	April 19, 2020
Extracting specific rows from data table: "Source contains no data rows" Studio	4	1885	October 24, 2021
Excel conversion Studio studio , question , activities_panel	9	1012	December 14, 2021

Most Active Users - Yesterday
prashant1603765
gorby
sharazkm32
pabaleloh
More details...

Extract data from excel sheet to build a datatable

Related topics