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.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Hello,
I am working with a twitter data set and some of the individual tweet information was carried over to the following row. Where 23231320 should line up, the 73 should line up, and the other two following in those null spaces. Pretty much, the 4 nulls in row 45 should be replaced with the 4 values in row 46. It appears at random throughout the entire data set. "73" is the only consistent value throughout the data set.
This being said, I am hoping someone can help me clean up this issue. Please help!
Hi @Jay_Koda ,
Attached is an example showing how to do it.
My idea was to identify the columns that differ based on the null value in last column.
Best,
FErnando Vizcaino
Thank you, but this seems to only work for the one record rather than multiple records that are random throughout the data set
I've created more lines to the example and it worked like a charm!
Take a look and let me know if this works for your data as well.
Best,
Fernando Vizcaino
The formula tool dividing/round/multiply to get matching recordID's was not working for me. This being said, I replaced this with a multi-row formula tool and wrote a conditional statement to replace the recordID with the following row ID if a Null was present.
Thanks for the advice and help!