Hi All,
The attached file is a *.xml file layout that I get from a system file. I can extract it and load it in to Alteryx, but I need to take a value and use that in a new column to append each record with a branch code!
So in the xml file, I need the KeyName Company value (02, 03 etc.) to append to each subsequent record as it loads in to Alteryx
So the file looks something like this
When it reads the "Company" code, each subsequent line until it reads the next "Company" code needs a new field called branch with the relative company code. the code must be a minimum two characters long in the output, I assume I can use a formula to pad out the field and add a 0 to the left if required.
TIA
