Merging each output result sheet

[sluree0732 (상태 김)]

I have two questions. Help me

1. I’d like to add a column called “Keyword” to column A to get the values in the dt_Keyword data table, what should I do?

2. I printed out the result value in the DataTable called “URL” on each sheet, and I want to combine the results of the sheet that is added while making a new ToDay sheet, what should I do?

Thank you.

[jack.chan]

refer to this xaml
merge keyword.xaml (16.1 KB)
logic:

1. get all excel sheet

for each sheet
   if sheet contains "Keyword"
         read sheet table
         add column "Keyword", default value = sheetName
         merge table to todayDt
write todayDt to Now.toString("yyMMddHHmm")

example

result

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20220512-1.zip (10.6 KB)

Regards,

[sluree0732 (상태 김)]

I’ll write it with reference.
Have a nice day.