I have two excel sheets with one containing 21 columns and another containing 3. The first column of both sheets have timestamp values.
The main sheet containing 21 columns has unique headers say a,b,c,d… and the second sheet has just three headers, the timestamp and, say, j and k which are also present in the main sheet.
The main sheet has about 7k rows with timestamps and values for each column a,b,c,d… while the second sheet has no rows.
I want to compare the headers of second sheet with the main sheet, that is, check if j and k exists in the main sheet, and if it does, I want to copy all the 7k values of j and k to the second sheet including the timestamp column.
Main sheet: Timestamp || a || b || c ||…
Second sheet: Timestamp || j || k
As far as I know, excel loop iterates over each row and if a condition is satisfied, writes into another column. Can I use excel loop or advanced loop activity to iterate over the column headers and if a condition in column headers is satisfied, write the whole column values to another sheet?
Thanks for your help. I’m using the CE of AssistEdge