I still work with Qlikview
I have an Excel spreadsheet with data. Colom A have a file reference and then contains other data in the columns to follow.
I have a 2nd spreadsheet with data that changes in a process. It ill contain the same file ref as the first Excel spreadsheet but then it will have status = 8 with a date and time and then later update to status = 1 with date and time. Both date and time data are important for me and I need to display both. However I have 2 records now and rather need to display column with file ref, then header = 8 with date and time and then header 1 with date and time and 0 if there is no data on 1 line only.
I have this:
File Ref |
Status 8 |
Status 1 |
Status |
230704610012 |
N |
Y |
1 |
230704610012 |
Y |
N |
8 |
But I want this, instead of the Y and N I will just add the date and time:
File Ref |
Status 8 |
Status 1 |
230704610012 |
Y |
Y |