Forum Discussion

Vosyn's avatar
Vosyn
New Member
5 years ago

XML Query has Values and Nested Tables. How do I retrieve the first value of the table?

Just for some background - I am completely new to Power Query. I downloaded all public XMLs from clinicaltrials.gov and would have sorted the files I needed. I run a Power Query on the folder (which ...
Need Help
Vosyn's avatar
Vosyn
New Member
5 years ago

I have been using conditional columns with the function "=Table.FirstValue([start_date] as table)." I get close to what I need. However, the issue I have now, is that if the cell already contains a date, this function will just return Error into the cell.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Vosyn,

     

    Try to modify the code.

    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File","Sample File")),

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!