masterelaichi
New member
- Joined
- Feb 27, 2019
- Messages
- 25
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2016
Hi,
I am trying to profile some tables I have in an sql database. The scenario is there is a column containing nested tables and I want to sum a specific column from each of the table and add it as a new column to the outer table
However, when I try to sum the column of the inner table I get this error "We cannot apply operator - to types Text and Text". I know this is due to a dataype of the sales column of the inner table. I have deliberately set this to text to replicate the datatype in my sql table.
Basically, I just want to add an extra column to the outer table that contains the sales for each month. In my actual dataset, I need to add different columns based on the filenames
I have attached a screenshot and the sample excel file if it helps
Thank you
I am trying to profile some tables I have in an sql database. The scenario is there is a column containing nested tables and I want to sum a specific column from each of the table and add it as a new column to the outer table
However, when I try to sum the column of the inner table I get this error "We cannot apply operator - to types Text and Text". I know this is due to a dataype of the sales column of the inner table. I have deliberately set this to text to replicate the datatype in my sql table.
Basically, I just want to add an extra column to the outer table that contains the sales for each month. In my actual dataset, I need to add different columns based on the filenames
I have attached a screenshot and the sample excel file if it helps
Thank you