Hi I need help creating a workflow in Alterxy for the attached data file. I received this report every week for billing. So i want to create a workflow where I insert the file and it automatically generate as shown in the pic. I'm trying to assign each client name and want the final output to look like this with each tab has client name with their billing info. First I took out the "Total" rows using the formula: IF Contains([Emp Name], 'Total') THEN Left([Emp Name]) ELSE "" ENDIF in to a new column named "Primary ID" just for now. then im trying to use multirow formula to assign each client name and code to each of the employees above, but formula (IF IsEmpty([Primary ID]) THEN [Row+1:Primary ID] ELSE [Primary ID] ENDIF) is not working for me as it's only assigning 1 row on top, but I was to assign to each of the employees name above.
