How to Add new columns as many as datatable rows?


There are a few things I would like to ask about the DataTable.

  1. The green box is the DataTable with data scraping completed on the airline website.

  2. Complete the data scraping of only the airport name on the airline’s website and convert it to a code.
    (ex)Japan -> JP)
    (ex)GimPo -> GMP)

  3. Enter the airport code as many as the number of rows in the green box.

How can I proceed?

Any help would be appreciated.

Hi @bin0901200055 how u get the code?

It is still in practice, so the user specifies the code.

If I know how to get code then

Inside a loop use write cell activity to write the code on the that column with cell incrementing after every iteration

Hope it helps

Nived N :robot:

Happy Automation :slight_smile::slight_smile::slight_smile::slight_smile: