Help

Automation question - Running change

Topic Labels: Automations
Solved
Jump to Solution
301 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Yerko_Begic
6 - Interface Innovator
6 - Interface Innovator

I would like to run Automation every week on Sunday, and the purpose is to have a running change for my Pivot Tables. I would like to take the "Items", "QTY" and "Last Date/Time Updated" from Table1, and copy/ paste that data into the Table2 which has the same column names. Is this possible and how is it done? I was poking around and wasn't able to figure it out.

1 Solution

Accepted Solutions
Yerko_Begic
6 - Interface Innovator
6 - Interface Innovator

as able to solve my problem with the Java Script.

See Solution in Thread

4 Replies 4

Could you provide some screenshots of how the data looks in Table 1 and your expected output in Table 2?

 

Here is my Table1

Yerko_Begic_2-1711076584338.png

And here Table2

Yerko_Begic_3-1711076607689.png

I would create PivotTable based on Table2 to track my weekly/ monthly/ yearly data 

 

 

Let me correct one thing... There are going to be other columns in Table1, but I only need "Items", "QTY", "Last Date/Time Updated" and "Value" to be grabbed and moved over to Table2

Yerko_Begic_0-1711078110421.png

Yerko_Begic_1-1711078130101.png

 

Yerko_Begic
6 - Interface Innovator
6 - Interface Innovator

as able to solve my problem with the Java Script.