Multiple spreadsheets to run with single date.

Question

I have several spreadsheets that I need to pull from. These spreadsheets have different date formats (some in column headers) and are all added as Different Inputs (some with dates across columns, other in a single column)

I need to filter the data in 2 ways before using it.

1. pick up the individual date from the data (where the date is a column name) and the values I need are underneath it.

2. Rolling 18 months from the date

I’m wondering if there is a way to get a single user input I.e “2022-01” and to pull this data in? And to filter the data down to just what I need? Before going ahead and using it?

I can usually do this in a database by using a parameter on the sql statement, but not sure how to do it with spreadsheets?

Thanks in advance for the help!

Emmanuel_G · Answer

Hi @D-VA ,

Can you please share an example of excepted output with these inputs ?

D-VA · Answer

I don’t have access to my laptop but essentially

Input 1

name, department,2022/03/01, 2002/04/01

userA, sales,41,46

input 2

Dept,name,2022/03/01

sales, userA, 19,26

Inout 3 (12 month rolling sun required)

user, department, sales date, sales value

userA , sales, 2022/03/01,5

userA , sales, 2022/04/01’16

Input 4

user,dep, SD2203,SD2204

I just want to specify the date once in the beginning of the workflow (like a parameter or variable)

btw this example is over simplistic with some of the data having over 60columns that get put into the right format after a whole bunch of summarising.

Qiu · Answer

@D-VA 
It will be much better if you can provide some input and output. 😁