Extract Data Table - datas shifts

Help Studio
,
1

Hello everyone,

I’m using the “Extract Data table” activity to extract the table from this website. However, my data is out of line with the columns. I think it’s due to the first three columns with image, but even if I remove them from the extraction, it shifts everything.

This is sensitive data, so I’m taking the liberty of blurring some of the data :confused:

The wesite table :

2024-04-05_10h58_07
2024-04-05_10h58_071604×494 111 KB

The data extract table :

2024-04-05_10h27_07
2024-04-05_10h27_07777×689 52.1 KB

The first column is empty and the contract numbers are found in the second. And when there is one more icon on certain lines, it shifts the columns even more.

If someone know how to help me :frowning:

Thanks !

2

@Christopher_p

as you mentioned yes when there is an extra icon extra column is getting added in the backend I guess so the values are shifting

try to indicate all column and all data and check if it works…else after extraction we might need to do some corrective action to shift the values

cheers

3

Thanks @Anil_G for your help. Even if i indicate all the columns, the shift is present :confused:

4

@Christopher_p

Then we need to do some massaging as mentioned after you extract and shift the values

The shift is because of extra icons that are appearing

Cheers

5

How can i shift manually the values ?

6

@Christopher_p

use a loop and inside it use if condition to check if the current row is havign value in the column you need…if not shift all the values of that row using one more loop on columns to left

cheers