Seperating Table , processing each table, then append to new 1 data table

So guys i want to ask how to process this data table,
main objective
1.Seperate Datatable based on Combine (A1,A2,NO COMBINE)
2.Process data based on seperated table
3.append all the result to 1 table
4.the vaariant doesnt affect the sperating of table , lets make it the type into value
5.reports column should be all have value on the new combined data table

the process can be simple type into , i just dont know hot to do this workflow properly

  1. original Data
    image
    2.Seperated Data A1
    image
    3.Seperated Data A3
    image
    4.Seperated Data No Combine
    image

if you have any other idea to process this workflow other than seperating it like this , please let me know

Hi,

I think it will be roughly as the following.

Sample20211217-2.zip (9.7 KB)

Hope this helps you.

Regards,

1 Like

yup im also using distict but seems like we have diffrent condition on disticnt but same result, can you explain what your disticnt do?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.