Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

CSV report is not splitting filters into different columns, just separated by commas.

Avatar

Level 1

CSV report is not splitting filters into different columns, just separated by commas.

 


 
Updating Media

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi, your screenshot seemed to fail so we can't really see your example...

 

However CSV stands for "comma separated values". 

 

Where are you attempting to open your CSV file? If you are opening it in Excel, do you have the correct column delimiters selected?

 

As you can see, in my Excel, "tab" is the current delimiter... so this isn't going to process a normal CSV properly:

Jennifer_Dungan_0-1658954456607.png

 

When I add "comma" as delimiter, the data preview now shows correctly:

Jennifer_Dungan_1-1658955031088.png

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi, your screenshot seemed to fail so we can't really see your example...

 

However CSV stands for "comma separated values". 

 

Where are you attempting to open your CSV file? If you are opening it in Excel, do you have the correct column delimiters selected?

 

As you can see, in my Excel, "tab" is the current delimiter... so this isn't going to process a normal CSV properly:

Jennifer_Dungan_0-1658954456607.png

 

When I add "comma" as delimiter, the data preview now shows correctly:

Jennifer_Dungan_1-1658955031088.png

 

Appreciate it, I now was able to split them using your instructions. Thanks!