I have a table with multiple rows, each row is a string that lists products sold for each day. I want to compare two consecutive rows, and display the difference of the two strings so that I can see what products sold yesterday, but not today.
Can I get the difference in string in Parabola?
Hi @Loan_Nguyen, welcome to Parabola’s community!
Showing the difference between two consecutive rows is doable in Parabola by splitting today and yesterday’s string of products into separate columns. From there, we can identify the day of the week each product was sold on, and re-combine the data to show blanks in products sold yesterday, but not today.
For a step by step guide on how to do so, please refer to the snippet below:
parabola:cb:30cf3afc-f821-496b-9927-ebb37183fc76
More information on snippets can be found here.
Please note: depending on your data source, the string may have to be split up using a different delimiter or method, and the date format can also be changed based on preference. If you need any additional help with this, please contact help@parabola.io.