bagaimana memilih cekbox sesuai kategori sebagaimana pada pic tersebut, dimana kategori no inv ada pada data data tabel excel, adakah yg punya solusinya ?
→ Use read range workbook activity to read the excel and store in a datatable variable, let’s name it as Inputdt.
→ You have to extract the table in the website by using the Extract datatable activity which allows you to extract the datatable and store in a Datatable datatype variable, let’s name it as Extracteddt.
→ Use for each row in datatable activity to iterate the each row in the Extracteddt datatable.
→ Inside for each use the assign activity and write a LinQ Expression to check your condition.
→ Take another assign activity to store the Type, let’s call variable name as INVType.
→ After assign activity insert an click activity and indicate the first check box and when indicating check the strict selector and uncheck the fuzzy and image.
→ Open the Ui explorer for click activity and select the attribute which contains the Type of INV and replace the text for that attribute with the INVType Variable.
Hope it helps!!