Forum Discussion
yanzhao_LBS
Helper II
1 year agoHow to get a table like this
I have 3 tables 1. 2. 3. and I want a table to display all the information detail like this: but it seems that it's ok to display the sum of them or one is sum the o...
- 1 year ago
It looks like the expected output only need the data from table 2 and 3.
You can create index and custom columns in PQ for both table, then merge two tables.
pls see the attachment below
ryan_mayu
Super User
1 year agowhen you are merging the tables, press ctrl and select product code and custom columns. You will see the numbers beside the column name. Make sure the numbers are matching in both tables.
yanzhao_LBS
Helper II
1 year agook.yes.that works.