Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Handle start end date in URL

Is there a way to list ALL contents and list per date in a column instead of date range together please?

 

 

let
Source = Web.BrowserContents("https://trendlyne.com/equity/calendar/all/all/?start_date=2021-11-09&end_date=2021-12-08&corporate_actions=Results"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE[id='DataTables_Table_0'] > * > TR > TH[colspan=""1""]

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please have a try.

    Click on Transform Data>>Home>>Advanced Editor.

    Then change the start date and end date.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    I don't quite understand what you mean. I have got the tables from the Web. However, it is the specific date. Look like the following pictures.

    Please provide some specific data and expected output.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks. To clarify the quest - is there a way to get data for past dates besides what shows on screen?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Please have a try.

    Click on Transform Data>>Home>>Advanced Editor.

    Then change the start date and end date.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.