Rollforward dates with chains – Centrum wsparcia

Rollforward dates with chains

Udzielono odpowiedzi

Zamów wersję demonstracyjną

20/04/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

Komentarze

Komentarze: 2

Isabel Messore

20/04/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

20/04/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

Zaloguj się, aby dodać komentarz.