Hi everyone,
I'm seeking suggestions on how to perform batch editing to reconstruct this record:
The column size is fixed, but the row size depends on the number of sellers.
If you have any ideas or recommendations, please share. Thanks
Record Seller
seller Item_1 Item_2 Item_3 Item_4
1 mark apple amla annona avocado
2 john banana buns basket bars
3 karen egg eel wax shoe
4 joe lace paper shirt wire
Into
Record seller
item seller
1 apple mark
2 amla mark
3 annona mark
4 avocado mark
5 banana john
.
.
.
20 wire joe
Reconstruction
-
justinlakier
- Posts: 238
- Joined: November 21st, 2022, 4:41 pm
Re: Reconstruction
Hi,
I recommend creating a separate dcf with the record structures you want. You can then go through your input data using loops to grab seller name and item name for each item in each seller record, then outputting each to the new dcf in order. You may also want to include ID/Counters as a variable rather than just item and seller in this new record, since items aren't unique and if seller is now a repeating item it won't be a unique identifier for a record.
Hope that helps,
Justin
I recommend creating a separate dcf with the record structures you want. You can then go through your input data using loops to grab seller name and item name for each item in each seller record, then outputting each to the new dcf in order. You may also want to include ID/Counters as a variable rather than just item and seller in this new record, since items aren't unique and if seller is now a repeating item it won't be a unique identifier for a record.
Hope that helps,
Justin