DataTable Rows coming up with empty fields and duplicate values

I wish to gather data from tiktok website for research. I created a bot that should go into each profile, get some information and save it in a csv. I have used get text activity to read data, then add data row to add it to a datatable and then used append to datatable. I have looked at all options but it seems the output csv file has blank rows when there shouldn’t be. There are also duplicate rows. Please can anyone have a look at this?

Main.xaml (27.0 KB)

TikTokStats Output.txt (1.2 KB)

Here is the file and the output I am getting.

Hi @bokapakhi

Within Append CSV you have given the extension as .txt
Instead of .txt you should give .csv

I cant run your workflow bcz of the following issue

Hope this may help you to solve your query
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Yes, I’ve heard on the news about tiktok ban - no worries, I’ve made the changes and that worked perfectly, Thanks @Pratik_Wavhal !

Hi @bokapakhi

Cheers
You are welcome :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.