I want to make sheet 2 data from sheet 1 data
This is called a join, it’s a standard database operation. Load Sheet1 and Sheet 2 into datatables then use the Join Data Table activity.
Sheet 2 will consist of ID and whether the row from sheet1 contained issue or not i.e status
In Sheet 2 ID’s will be placed , i just want to derive status
That’s what a join is. It matches up the datatables based on the ID column and combines them into one datatable.
“Sheet 2 will only contain id” , NO status
I want to derive status.
I want to check each rows in sheet 1
Then read Sheet1 into a datatable. Use Build Datatable to create a dt for Sheet2 with columns ID and Status.
- For Each Row in datatable dt_sheet1
** If CurrentRow(“Value2”).ToString = “NoIssue”
*** Then Add Data Row to dt_Sheet2: {CurrentRow(“ID”).ToString,“ok”)
*** Else Add Data Row to dt_Sheet2: {CurrentRow(“ID”).ToString,“Issue”)
Another way…
Read sheet1 into a DT. Use Add Data Column to add a Status column to DT_sheet1.
- For Each Row in DT_sheet1
** If CurrentRow(“Value2”).ToString = “NoIssue”
*** Then Assign CurrentRow(“Status”) = “ok”
*** Else Assign CurrentRow(“Status”) = “Issue”
Then you can use Filter Data Table to create DT_sheet2 by keeping only the ID and Status columns from DT_sheet1.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.