Forum Discussion
Help please, guidance required
Please follow the below steps.
1. Right click on table (Ex:- DOP-055 1)
2. Click on "Duplicate", you will get another table. Remove unnecessary columns and keep required columns. (Ex:- ONo,DelNo,CusReqDt,DepDt,Item,ItemOrderQty,ItemDelQty).
3. Clcik on "Group By" based on columns. (Ex:- Ono - only one i used here, based on your requirement you can use the columns here).
4. Select the "Original Table (Ex:- DOP-055 1)" and click on "Merge Queries" and select the common columns and clikc ok.
5. Expand the column and select required columns and change the column by double click on it (Ex:- Cnt).
6. Click "Close and Apply".
7. Now you can able see the "Cnt" column in Main Table and Click on "New Column" and assign it as "Flag" and write a query like below.
Flag = IF(Snowy34[Cnt]=1,"True","False")8. Based on your requirement, if the Flag have true, it is nothing but "perfect order".Hope it will help for your requirements.Please refer the link for the snippets.If you have any queries, please let us know.
Please follow the below steps.
1. Right click on table (Ex:- DOP-055 1)
2. Click on "Duplicate", you will get another table. Remove unnecessary columns and keep required columns. (Ex:- ONo,DelNo,CusReqDt,DepDt,Item,ItemOrderQty,ItemDelQty).
3. Clcik on "Group By" based on columns. (Ex:- Ono - only one i used here, based on your requirement you can use the columns here).
4. Select the "Original Table (Ex:- DOP-055 1)" and click on "Merge Queries" and select the common columns and clikc ok.
5. Expand the column and select required columns and change the column by double click on it (Ex:- Cnt).
6. Click "Close and Apply".
7. Now you can able see the "Cnt" column in Main Table and Click on "New Column" and assign it as "Flag" and write a query like below.
