Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Combine search results - or find a smarter way for my search
I have 3 searches on customers that have fields ID, Company Name, Discount
Search 1 uses Discount1 field, search 2 uses Discount2 field, search 3 uses Discount3 field.
Looking at the customer record there are 3 discount fields: Discount1, Discount2 and Discount3.
I need to produce a CSV file with:
Cust1, Cust1 Name, Disc1
Cust1, Cust1 Name, Disc2
Cust1, Cust1 Name, Disc3
Cust2, Cust2 Name, Disc1
Cust2, Cust2 Name, Disc2
Cust2, Cust2 Name, Disc3
etc.
It is easy to produce a search with Cust1, Cust1 Name, Disc1, Disc2, Disc3 but that is not what I need.
In SQL terms I could do a UNION query.
0