Generate CSV with single column
Options
tomas randomas
Member ✭
Hello, trying to generate a CSV file with 1 column and for some reason all rows are treated as columns instead, not sure if that is a bug or not, maybe someone would have a better idea : )
Tagged:
Best Answer
-
- If there are no commas to delimit the columns, you might have an easier time using the "join" filter on your array to connect all the elements with newline characters so it's one-per-line.
So for line 5 in your function stack:
- Create variable
- Set the variable name to csv
- Set the value to column_name (the array)
- Add the filter join
- Add the separator of a newline character
- Dealing with this kind of one-off data manipulation falls in the category of "the hard parts" that we work on in the State Change Pro community and in our daily office hours. (Tomas is an alum!)
- If there are no commas to delimit the columns, you might have an easier time using the "join" filter on your array to connect all the elements with newline characters so it's one-per-line.
Answers
-
Thanks @Ray Deck! It was a while since I had to ask a new question, you're a good tutor!
To anyone who might stumble upon this, I solved it like that, and it completely makes sense.. each row as a new array (within rows array)
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback