This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have data shown below. If last is TRUE or FALSE for Each id i need all the values should be either TRUE or FALSE like shown below.Thanks!
There's a couple of easy solutions for this problem, you can use a filter and join tool, or you can create a 'fill down' using them multirow formula tool.
I've attached examples of both.
I'd use a very simple Summarize Tool and then join it back to your dataset.
Sample workflow as below.
Thank you everyone.
I have data like shown below. I need to subtract the dates for each id and get the number. Can anyone help me for the formula. Thanks!
Do you need to measure the difference of the dates in days?