Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a spreadsheet that has a column (Material) that contains thousands of values. I've isolated all of the values (thousands) that I do not want to load in a separate workbook (ExcludedMaterials). Now I'm looking for a way to load the entire spreadsheet except the rows where the value in the Material column matches a value specified in the ExcludedMaterails workbook.
Is there a function that allows you to load all values except those specified in another list? Thanks for any and all help!
Try something like this:
Excluded:
LOAD Material as ExcludedMaterial
FROM ExcludedFile;
Table:
LOAD Material,
AllOtherColumns
FROM File
Where not Exist(ExcludedMaterial, Material);
Try something like this:
Excluded:
LOAD Material as ExcludedMaterial
FROM ExcludedFile;
Table:
LOAD Material,
AllOtherColumns
FROM File
Where not Exist(ExcludedMaterial, Material);