I’m looking at multi city pair airport list to identify the cheapest flight for each route.
I’m doing a for each statement pulling the rates for each leg. Within the data scraper I’m then sorting and deduping the cost to come out the cheapest flight. My issue is when I combine all the data and output the excel document. My output is City pair, cheapest flight, return cheapest flight, date.
The cheapest flight and return cheapest flight have the header of the data scraper imbedded within the price. I haven’t been able to figure it out. I’m sure it’s how the table is being defined but I’m at a loss.
Ex: Lowest Cost $59
The data scraper works by itself. It’s when I add it to the for each loop that the headers are imbedded within the output.
As a new user I’m unable to upload the xaml.
Thank you in advance