PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/20/2017 10:41 AM by  thummel1
CSV as Data Source for SN
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
03/20/2017 10:41 AM
    Hello, looking to use a CSV file as a data source for smart notes. The SN would need to look for null values in a string field. Eventually, there may be more conditions to look for (e.g. Column 1 is null, or, Column 2 = Y and Column 3 = No).

    Is this possible conceptually? I was able to set up a CSV file as a data source, but am stuck here and have several questions such as: When I update the Info Set it returns an 'errors' message, but I can still preview the data? Do I need to create a measure on said fields when defining the Info Set? How should the notification be set up to look for null values?

    Any tips are welcome!
    Tags: CSV
    You are not authorized to post a reply.