Rollforward dates with chains – Support Center

Rollforward dates with chains

Answered

Request Demo

April 20, 2023 17:12

Hi!!

I want to store the column number where a specific value is located in a cell of a spreadsheet with chains in Workiva. Is it possible?

0

Comments

2 comments

Isabel Messore

April 20, 2023 18:56
Hi Mounir Chebicheb de la Torre,

Yes, this is possible! I've contacted our Data Management team who will connect you with a PSM. Let me know if you have any other questions!
0
Jeff Hickey

April 20, 2023 22:43
Hi Mounir Chebicheb de la Torre,

You likely could do this by first pulling the Sheet data with the Workiva command Get Sheet Data. Then within the Tabular Transformation commands, you can Add Row Numbers if they are not yet already in your data, and finally use Filter Rows and/or Advanced Query to narrow down the data based on the specific value. After filtering, the remaining rows will include the row number. These steps could also be done within a Pipeline in Data Prep.
0

Please sign in to leave a comment.