This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need assistance with figuring out how to fix the following problem below. The data listed is sample data but the data I received is a much larger set with more columns.
From the Input Table, you can see that the addresses were mapped incorrectly past the "Fist Name" column. I create the "Last Position" column and the "Offset" column to figure out how many columns each record is offset by. If the "Last Position" record is empty, the "Offset" returns 0.
Given the values in either the "Last Position" and "Offset" columns, how would I go about returning the records for the columns in the correct column and record order?
Thanks for providing the solution. The WF works awesome on my end for the provided scenario. Since my original data set is slightly more complicated, how would you handle the problem if the other columns are not empty? I filled in the empty fields with random strings as an example: