many nodes (authors) during xml import

In developer tab I choose my xml source and generate an xml map. Then I place fields I need inside a Sheet. Problem is that it only displays the first node (author of the publications, when it should display 5). I need something like Autor[1], Autor[2]. How to display multi node data?

Attach a sample xml file not image. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

okay, so before sheet shows how data from one entry is divided into rows, but i'd like to have one row like in csv.
xml can be downloaded from here: http://dentopolis.org/pubmed.xml

is that what you want?
Done with PowerQuery

btw. your profile says you've Excel 2003 but file is from higher version so update profile about your real excel version

I've managed to use get columns i neewith Power Query, but as in s666-PQ-xml import.xlsm‎ there are many rows for the same article. how to export it to have tags in one cell divided by "," and authors in one cell divided by ","? (I need to export it to csv)

Group by what you want in PQ editor then load to the sheet then export to csv with comma delimiter

I've tried to follow your steps in advanced query editor but stucked with merging. could you please help me
1)create new column called Background (with text in rows), Methods, Results, Conclusions
2)merge keywords and authors if they are already extracted

1. Could you update profile about real excel version?
2. I'll check xlsx post#9 later

First of all I got this:

pq-sourceerror.jpg

I tried change source to xml you gave before but it doesn't work (probably structure is not identical) so attach this "new" xml and list which nodes you want to get from
in your example a few columns has the same value from the top to the end, do you really need it ?

here is the way how to add files to the post. if any extension is not supported, zip it then attach


To attach an Excel file to your post,

• desensitize data
• remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

that's strange that you can't open this file. it's simply an export from https://www.ncbi.nlm.nih.gov/pubmed/?term=dentistry
i limit number of publications on the left panel and on "Sent to" I select File->XML

1. how many rows you see loaded in PQ editor?
2. I don;t know your criteria so I can't limit
3. I see there "download csv" and you said you want csv, so ...?
4. did you try group like I said in post above?
5. could you use english version of Excel ?

1.2571 rows

2.later i will use large xml export for a whole 2017 year, right now you can export any data range just to have an xml structure.

3.their csv doesn't contain all the fields like Methods, Results etc.

4.when i try to group (different settings) I'm getting the same error:
Expression.Error: Can't convert "Modern treatment of ..." to type Table.
Details:
Value=Modern treatment of patients with oncohematological diseases has allowed to achieve remission or even convalescence in many cases. One of ambitious aims put forward by the hematological society is 100% survival and preservation of quality of life in patients with chronic myeloid leukemia (CML). This hope is related with the emergence of targeted therapy for CML. The second-generation tyrosine kinase inhibitor, dasatinib, which is used for treatment of CML, can occasionally induce severe pulmonary hypertension (PH). We presented here a case report of such cardiotoxicity, which was evident as PH and heart failure in a young female patient with CML treated with dasatinib. Information from published reports about this type of cardiotoxicity is provided. At present time, dasatinib is beginning to be extensively used also in other oncological diseases. For this reason, cardiologists and physicians should be aware of this cardiotoxicity, which can cause heart failure in dasatinib-treated patients.
Type=Type

5.i will download english version and try again tomorrow.

I see you forgot about xml again

no source - no data - no answer

and maybe try to use the same source, not changing everytime

xml source http://www.dentopolis.org/2018.zip

I'm using smaller file because working on final file that is loading for a few minutes is killing me
later on i will use this action on large final file.

and i was going step by step through your example with authors and keywords but there was no abstract with results, methods, etc and I couldn't find a way to add it.

You can add step between others. click on step where you can see node which contain abstract and select from there what you want

I try and try and still I can extract AbstractText not Background, Methods, Results, Conclusions.

some PubmedArticle nodes contain keywords, some don't. sometimes there is only AbstractText, but usually it contains four Labels (Background, Methods, Results, Conclusions).

structure of file I need:
ArticleTitle | AbstractBackground | AbstractMethods | AbstractResults | AbstractConclusions | Date | ArticleTitle | Authors (divides by ,) | Keywords (divided by ,) | PMID

just sample of 2018.

custom column Background should contain AbstractText with Label "Background" etc

ok, thanks for answer.

tomorrow

Here is
what you will do with Abstract text and Label it's up to you.

XML is full of holes so hard to extract appropriate nodes which are, IMHO, not paired well

sorry but EF again said NO so you can download rar from here: file to download and let me know if you do this

If that takes care of your original question, & to say Thanks and for better Motivation, please

1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
   then
2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.

If you did it already - ignore it.
Thank you.