mc1392

works like a charm! thank you!

I think I found the issue. When I print my values in Eclipse (IDE) I realized the Console is probably chopping my query. ( I generate the query using java in Eclipse). I wasnt getting the entire query when I copy-paste, I think that is issue. Therefor, I was missing records in the results count.

This is what works: csvInput += "\""+contact.getFirstName()+"\","+ "\""+contact.getLastName()+"\","+ "\""+contact.getPhone()+"\","+ "\""+contact.getCompany()+"\","+ "\""+contact.getEmail()+"\","+ "\""+contact.getID()+"\","+ "\""+contact.getDegree()+"\","+ "\""+contact.getBadge()+"\","+ "\""+contact.getMailStreet1()+"\","+…

When I look in DOMO, on the data set page, I see this message: "The import has been cancelled because a new request has been submitted."

"Critical Care" will not show in both columns. It will appear in only one of the columns. I want to count each occurence on each row.

Yes, I'd like to get the integers to show. The counting will be a card feature. I hope to then use a Legend: 1 = "Critical Care" 2 = "Another item" 3. .....etc

Found the problem! On the ETL/Blend screen, scroll down to the 'Preview' area. On each column is a tick, to select 'Include column' !!! DUH!!!