Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am quite new in development in QlikView scripting and I would like to ask for help.
My original data consist of 3 columns: Date, Part_old and Part_new. When there is just one change there is no problem for me to write script. Problem is when, like you see in example a part 'aaaa' is replaced by 'bbbb' on January 1st and afterwards the part 'bbbb' to 'eeee'. Below you can see the original data structure and the desired new layout.
I thought about do while statement, but I am not able to declare variable which will take the value from column C, check the whole column B to find whether there is more replacements of part and write it in a way I described above.
Thanks for help
Michal
Dear Michal,
This is called slowly changing dimension. Please check listed below article,
IntervalMatch and Slowly Changing Dimensions
Kind regards,
Ishfaque Ahmed
Why is bbbb the Partold_original of cccc?