Hi,
I have a query that has an API call to a table that returns an XML. Due to limitations on the API, I need to call the API for multiple pages. For some reason some of the columns are being returned as a single Text Value (or Date depending on the column) on one call but a Table Value on another.
Advanced Editor:
Sample output (this is also happening to a number of other columns):
Is there a way to stop having these incorrectly set as a table value?
A way to convent just those that have been incorectly set as a Table Value?
Any help is appreciated.
Thanks, Reece.
Hi @Reece_EC ,
Sorry for that the information you have provided is not making the problem clear to me.
Do you want to keep on expanding Table values ? Or just filter out Table values?
Best Regards,
Eyelyn Qin
Hi Eyelyn,
I am wanting the data in the "table" fields shown in the column just list the rest of the data in those columns.