core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
I got there, but I feel like my solution is too complex. Curious to see other options.
Dipan Mitra => Challenge #49: Reformatting Transactional Data
My solution
#49
My solution uses append tool instead.
My solution!
Two options:
1. hard coded lookup (switch statement) based on F value to Market, Product and Type.
2. Generate a lookup from F value to Market, Product and Type from the Header rows (better).
Attached my super long solution.
1