Can i connect these comma separated values?

Matthias Seebo

Ich have a text-field (single) with maximum of 8 kommaseparated values like 11,32,35 and so on. These numbers (ids) are coming from a csv-import from wordpress. These numbers are ids of a categories-table. Is it possible to connect these two tables in any way? Needs to be done just one time.

Cameron B

It sounds like you might need to devise a function that separates each item in the list into their own items and creates the relationship that way. Mind sharing the schema?

Louis Machado - CSA

Hello Matthias,

Is this the task you're attempting to accomplish?

https://www.loom.com/share/7a8f5b2bfcdf4ed09a93f00fd30e8e10?sid=839b306d-d01f-4215-9c2a-43faa1be75ad

Matthias Seebo

@Cameron B Yes Cameron, i think i have to code a function for that. Is there an easy way to share the schema? I havn't done this yet :-(

@Louis Machado - CSA Kind of. I have to go through the datasets like in the video, but i have to seperate the values in that one cell with the comma-seperated values(plain text, no array) either. Maybe also with a for/each?!

Louis Machado - CSA

If you want to separate a plain text value with a separator, you could use the SPLIT filter and it will become an array of text values. Then, you will need to use a FOR EACH LOOP to iterate through this array.

https://docs.xano.com/working-with-data/data-type-filters/text-filter#split