Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to create a new table with data pulled from another existing table in the data model. I have a table named AllTimeMega that has already been loaded to the data model. I am now trying to create a new table named BestMonthSales that contains certain fields from AllTimeMega. Seems like a pretty straightforward task but I keep getting field not recognized errors for each of the fields. I have researched this a lot and have no idea what I am doing wrong. My script is below. Any insight will be greatly appreciated.
Load Field1, Field2, Field3
Resident Table1;
That extra select is getting in the way, I think.
Load Field1, Field2, Field3
Resident Table1;
That extra select is getting in the way, I think.
I'm still getting field not found for 'Month'
EDIT: Disregard that fixed the problem. Thanks!