Rollforward dates with chains
已回覆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?
-
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
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請登入寫評論。
評論
2 條評論