Forum Discussion
Adding Date Table to WDATP Connector generated Tables
Hello, I am trying to add a Date Table to the WDATP connector created fields and create a relationship but can not do it as there are no related fields (primary Key right). The WDATP connector uses the id, Machine Id Column as their primary key. My problem is that I can not add that data to the Date Table as I can not import it in. If anyone has an idea how to do this I am all ears. I appreciate the assistance.
Hi Darshawn,
Based on your description, the "WDATP Connector generated Tables" is using direct query mode and you want to merge it with a date table or create a chart using data from two tables, right? To merge them, I'm afraid you should change the direct query mode to import mode and try again because you can not change data model when using direct query mode and data refresh in a same chart should be synchronize so you also can not mix data in import mode with data in direct query mode in a same chart.
Regards,
Jimmy Tao
2 Replies
Hi Darshawn,
Based on your description, the "WDATP Connector generated Tables" is using direct query mode and you want to merge it with a date table or create a chart using data from two tables, right? To merge them, I'm afraid you should change the direct query mode to import mode and try again because you can not change data model when using direct query mode and data refresh in a same chart should be synchronize so you also can not mix data in import mode with data in direct query mode in a same chart.
Regards,
Jimmy Tao