I have 8 custom fields on an item record. How can ...
# suiteanalyticsg
Gregory Jones
09/20/2021, 1:02 PMI have 8 custom fields on an item record. How can I get the values of these fields to be in one column in a saved search? And not like, concatenated. I'd want a separate row for each populated field on a record.
c
CD
09/20/2021, 1:42 PMSo if you have 3 populated custom field for a given item, you want 3 identical rows (apart from the 1 custom field value)?
g
Gregory Jones
09/20/2021, 1:44 PMCorrect.
k
KevinJ of Kansas
09/20/2021, 7:46 PMCan't be done
party furby 1
😀 1
g
Gregory Jones
09/20/2021, 9:47 PMI was anxiously awaiting @KevinJ of Kansas!
Gregory Jones
09/20/2021, 9:47 PMDarn.
k
KevinJ of Kansas
09/20/2021, 10:50 PMSorry. Been taking some time off between jobs.
👍🏻 1
KevinJ of Kansas
09/20/2021, 10:51 PMThis *might be possible with sql
KevinJ of Kansas
09/20/2021, 10:51 PMSuiteQL
g
Gregory Jones
09/21/2021, 12:18 PMCongrats on the switch! I have 8 separate saved searches that I combine through power query, which works fine, but I was hoping to consolidate to one. I was thinking that it could possibly be done through SuiteQL, however I've never used it and not sure if I have access to it.
c
CD
09/21/2021, 12:19 PMYou can do it with a DISTINCT and a load of UNIONs
g
Gregory Jones
09/21/2021, 12:19 PMIn SuiteQL?
c
CD
09/21/2021, 12:19 PMYes
g
Gregory Jones
09/21/2021, 12:20 PMGood to know, and I figured it would be UNIONs