How to compare 2 File different csv & excel

Help Forms
, ,
1

Halo kakak" mohon bantuannya bagaimana ya cara mengcompare 2 file yang berbeda contoh datanya dan tabel yg berantakan

Screenshot (6)
Screenshot (6)1440×900 140 KB

2

Hi @Muhammad_Taufik_Akbar ,
I think we need handle bq-result file before compare
with each row we need split by “,”
then get new data table
to compare with 07.Data file
Can you share your file?
if can not public you can send to me by message
I will test for detail
regards,

3

@Nguyen_Van_Luong1 sorry dude i can’t. the data was private by company. so can you just teach me with the dummy data

4

Yes, you can create demo data, with original format

5

check the message my guy

6

OK, I replied you
I will check they with my code

7

Hi @Muhammad_Taufik_Akbar

Use Read range workbook activity to read the excel file and store in a datatable. Let’s name this datatable as dtExcel.
Use Read csv activity to read the csv file and store in a datatable. Let’s name this datatable as dtcsv.

Use for each row in datatable activity to iterate the rows in the excel.
You can use the If condition to check the condition if it is messy but you have to clear about the column names.

Hope it helps!!

8

can you give me the example