how can you export a reference column to CVS?

[ntra508]

Hi, how can you export a ref colum (not ref_rows) with another colum linked to it ? or a searchable  ref_rows that i can export via parent-child table relation ship?

[mateo]

Hi @ntra508 
I am not sure if I understand your question properly but take a look at this:
https://help.appsheet.com/en/articles/1090811-dereference-expressions
Hope it solves your problem!

[ntra508]

Hi @mateo  so in the Automation>task>make a file. I trying to export an cvs file.

but my I built a my data like this

page i wanted to export------List-----------reference colum-----------------list

when i insert  

<<Start:[List]>>

<<Start:[reference colum]>>

<<Start:[list]>>

[query]

<<End>>

<<End>>

<<End>>

it didn't work and return reference column is not a list type 

[mateo]

Sorry, I do not get what you really wanna achieve. Can you show an example of your expectations maybe?

[ntra508]

I'm sorry if I bothering you but i cant figure how to explain it to you. So here it my best explanation. I try to get the export a data behind a reference Colum like this one

and here is the data the reference Colum link to and it also the data i want in my cvs

[mateo]

You mean sth like this? Give it a try 😊

<<Start: [Related Quote Venues]>><<[Venue Name]>>

<<[Venue ID]>>

<<[Option ID]>><<End>>

[dbaum]

If I understand correctly what you want to accomplish, the separate thread about Create .csv file containing all child rows with a given parent id has additional helpful explanation of the technique that @mateo explained.