Hello, we are conducting a longitudinal study and we have multiple data-dictionaries of 5 different surveys including new questions and repeated questions with minor differences between them. Would you have an idea on how to best present them into one excel spreadsheet using dataiku (questions and their differences across all surveys) ? Thx
Have you created DSS datasets from the 5 data dictionaries? If so, you can try a Join or Stack visual recipe to merge or concatenate the datasets into one dataset. You can also use a Python recipe to merge/concat the data into one dataset. DSS supports excel format and you can export your dataset as an excel file.
Is the goal to export the merged data, create visualizations in DSS using the data? If you can provide more information, I'd be happy to provide further guidance.