Public
Edited
Jan 3, 2024
workbook = FileAttachment("NetSuiteData 2023.11 YTD.xlsx").xlsx()
rawData = workbook.sheet(0, {
headers: true,
range: "A7:Q30000"
})
data = rawData.filter(
(row) => !isEmpty(row["GL Account"]) || !isEmpty(row["Financial Row"])
)
function isEmpty(str) {
return !str || (typeof str == "string" && !str.trim());
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
