Forum Discussion

red_arrowhead's avatar
red_arrowhead
Helper I
5 years ago

How to create a matrix visualization with data from different tables (fields) with same column names

I have to create a matrix visulization with data from two different tables. I have column named Type in both the tables and 53 more columns for calander weeks with data for those Types. I have to cre...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
red_arrowhead's avatar
red_arrowhead
Helper I
5 years ago

Thanks for the reply. As suggested I have created the common bridge table. I have used the 'Type ' column as the common bridge. But when I put data in matrix visulization data from table 1 is inputted in columns for CW 01 to CW 53 and for the next table it again inputs a new CW 01 to CW 53 columns. I want all the data together. I mean, CW 01 data for both tables should come in CW 01 column together for specific 'Types'. How can I proceed for that?