Want to make date table in one from multiple date columns in single data table
Hi all,
I come across a challenge in Qlik sense scripting. I have a dataset in which there are 3 date columns such as, order_date, delivery_date, and review_date. My concern is to get all date columns in one date table. As of now, I am writing 3 resident load scripts for each column as shown below:
table_date:
Load order_date as date Resident table;
Load delivery_date as date Resident table;
Load review_date as date Resident table;
Is there any possibility that we can write a single resident load or minimal code to fetch all date columns from a single table plus all get concatenated into respective table under the date column?
