Forum Discussion
Helper IIHow to get a table like this
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
Super UserIt 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
Helper IIanother question ,if i don't know which type has the larger number of record,(in this case,request count is bigger than consume,so i can merge like this way) if I dont know which one has the bigger number or it changes all the time ,does it work also?
- ryan_mayu
this solution doesnot conisider the number of rquest and consum qty.
It only depends on the rows of each product code.
- yanzhao_LBS
but if i merge like this (conusmed is on the top)
the result will be like this