Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi @Venky_1992 , i have attached a flow that gets to your output.
Up to the union is just making sure i dont lose the data that was currently being brought in as a field header in the excel flow.
This logic relies on the fact that every entry has an access row and that it is the last one for each record. I can then make a recordID that allows us to cross-tab.
Ultimately, a solution to this is usually a case of identifying a feature in the data that is consistent and allows you to determine when a new record starts.
