Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.