How to format extra rows in Extracted Table Data

[qwerty1]

Hello,

I have an issue when extracting table data from a internal website.

When i extract the data using the wizard, the preview data shows me this:

When i loop through the dt & write line I get:

Column-0 , Column-1
1 , reference123
2, test456
3, ref789

I need:

Column-0 , Column1
1 , reference123 987 Main Street
2, test456 123 High Road
3, ref789 4 New Street

Is there a way to move the new row within column 1 up a level / format?

I have tried dt.DefaultView.ToTable("False, “Column-0”, “Column-1”) but this doesn’t seem to make a difference

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Hey when you loop on the dt to print values, take a counter when you extract the first value for Column 1 and append the value with the next iteration.Just some string manipulation and flags should do it.

[Yoichi]

Hi,

Can you try the following sample?

Sample20230602-3aL.zip (3.5 KB)

Regards.

[qwerty1]

Excellent! Thank you @Yoichi