Good morning,
This seems to be easy but can't quite land on getting it working. Basically we have an xls with Property File information. PIN's, Street Name, House Numbers, etc.
What we want to do is simply create a folder structure for all this information. We want Workflow to read each row in the Spreadsheet and create a certain folder structure (based on the information across the row). If I do a Query Data activity and can setup the ODBC and do a For Each Row. However it only goes to the first row. If I use a Custom Query I am unfamiliar with SQL syntax.
Basically I have a Create Entry inside the For Each Row activity. The For Each Row activity is getting its info from the Query Data results. But for Query Data is seems it only goes through one row and the Custom Query I am not sure of.
Any quick ideas? Again it seems like it should be something simple and it is probably something I am overlooking...
Thanks!
Edit: I have uploaded a few pics. Maybe I am going about it the wrong way but in summary I have the following.
I create a counter token and assign it the value of 1.
Then I Query Data and only retrieve the row of the according to the value of the counter token.
Then I create two entries.
Then I increment the counter by 1.
Then I assign the counter token to be the incremented value.
All of that besides the first creation of the counter variable is inside a Repeat. Just for testing the condition on the repeat is just if %(Counter) is less than 100. Don't need to do them all for testing.
I am able to get the first row done. The two folders create but it then does not move on to the second row of the xls.
Probably something simple..