I am try to run an update in the load script on a resident table.
The attached data show a sample of what the data looks like and the column I want to update RowNo.
I want to be able to update the RowNo column using the criteria;
Its the update syntax I am stuck on after the where.
(ooxml, embedded labels, table is Sheet1);
example.xlsx 10.4 K
In your case this would be enough:
LOAD * FROM [lib://Data/example.xlsx]
(ooxml, embedded labels, table is Sheet1) Where RowNo < 4;
In cases where you couldn't do your transformation with a single load you need to use the key-word noconcatenate to keep both tables then if there are tables with the same datastructure they will be automatically concatenated:
NOCONCATENATE LOAD * Resident example Where RowNo < 4;