How can i export data from portal in separated columns in Excel ?
Go to the related table (table occurrence) and export from there.
You can choose the fields if you use Export Records you use what is on the layout if you use Save/Send Records (as Excel). Choose the fields can be from any TO, but the context (parent or child) will give you a different perspective. Try it out from both an see what you get!
Or do you want this?
parent field 1 | parent field 2 | portal row 1 | portal row 2 | portal row 3...
As mentioned, export from the Child Table. If the export will be repetitive, I create a layout specifically to export. If I need Parent-Table fields as well, I can include them. I lay out the fields in the order I want, so I can view the data selected before exporting. I can confirm the TO will be the correct one.
I do not understand you
You do not understand any of the answers?
Are you exporting now (manually or scripted)? If you would take screen shots of your layout (Layout Mode) and any steps you take (every dialog that appears), please post them. Then we may answer your question more fully.
Sent from miPhone
I export manually. Can you tell me step by step how to export portal data to separated columns in Excel. I was looking for a lot, but I did not find anything that could help me
Please explain what you mean by “separated columns”.
The link between tables is "ID".
You want every related date to be a new column in the export. What you ask is not 'normalized' as parent one (John), has 2 new columns, and parent 2 (Luis) has 3 new columns, etc. How do you know the "maximum" columns to append?
1. why does it need to be this way?
2. what do you do if there are no related columns to append?
3. does it need to have column header(s)?
That being said, I might make a calculation (in Parent):
Quote(Name) & Char(9) & (Quote(Family) & Char(9) & Quote(ID) & Char(9) & Substitute( List(Doc. Date) ; Char(13) ; Char(9) ) & Char(13)
Then 'gather' that field (loop script) into one field (global). Use the TextEncode() to preserve the line-endings - push to a container - and Export Field Contents script step to export the container (give it the .CSV extension).
If you need a 'header', push this to the start of the gathering (before the loop):
"Name" & Char(9) & "Family" & Char(9) & "ID" & Char(9) & "Doc. Date(s)" & Char(13)
Open in Excel.
This requires FileMaker 16+
People who want this, they work only in Excel and want this.
Yes, of course they do! Excel-only users don't know 'normalized data'. LOL
Retrieving data ...