<ns0:LookupResponse>
<ns1:CUSTOMER_MASTER>
<ns1:CUSTOMER_ID>1324562<ns1:CUSTOMER_ID>
<ns1:LAST_NAME>Porter<ns1:LAST_NAME>
<ns1:MASTER_CUST_ID>225<ns1:MASTER_CUST_ID>
<ns1:CUSTOMER_MASTER>
<ns1:CUSTOMER_ADDRESS>
<ADDRESS_LINE_1>1234 Nowhere Dr<ADDRESS_LINE_1>
<ns1:CUSTOMER_ADDRESS>
<ADDRESS_LINE_1>2255 Somewhere Dr<ADDRESS_LINE_1>
<ns1:CUSTOMER_ADDRESS>
<ADDRESS_LINE_1>13546 Anywhere Dr<ADDRESS_LINE_1>
<ns1:CUSTOMER_ADDRESS>
<ADDRESS_LINE_1>502 OneTime Dr<ADDRESS_LINE_1>
<ns1:CUSTOMER_ADDRESS>
<ADDRESS_LINE_1>503 OneTime Dr<ADDRESS_LINE_1>
<ns1:CUSTOMER_ADDRESS>
<ns1:CUSTOMER_ACCOUNTS>
<ns1:CUSTOMER_ID>1324562<ns1:CUSTOMER_ID>
<ns1:Account_ID>1234<ns1:Account_ID>
<ns1:LAST_NAME>Parker<ns1:LAST_NAME>
<ns1:CUSTOMER_ACCOUNTS>
<ns1:CUSTOMER_ID>1324562<ns1:CUSTOMER_ID>
<ns1:Account_ID>12345<ns1:Account_ID>
<ns1:LAST_NAME>Priest<ns1:LAST_NAME>
<ns1:CUSTOMER_ACCOUNTS>
<ns1:CUSTOMER_ID>1324562<ns1:CUSTOMER_ID>
<ns1:Account_ID>123456<ns1:Account_ID>
<ns1:LAST_NAME>Givens<ns1:LAST_NAME>
<ns1:CUSTOMER_ACCOUNTS>
<ns1:CUSTOMER_ID>1324562<ns1:CUSTOMER_ID>
<ns1:Account_ID>1234567<ns1:Account_ID>
<ns1:LAST_NAME>Bell<ns1:LAST_NAME>
<ns1:CUSTOMER_ACCOUNTS>
<ns1:CUSTOMER_ID>1324562</ns1:CUSTOMER_ID>
<ns1:Account_ID>12345678</ns1:Account_ID>
<ns1:LAST_NAME>Booth</ns1:LAST_NAME>
I would like the results to be as follows(Each line represents one loop and then what is written to file)
1324562 225 1234 1234 Nowhere Dr Parker
1324562 225 12345 2255 Somewhere Dr Priest
1324562 225 123456 13546 Anywhere Dr Givens
1324562 225 1234567 502 OneTime Dr Bell
1324562 225 12345678 503 OneTime Dr Booth
The problem is I am getting the below:
1324562 225 1234 1234 Nowhere Dr Parker
1324562 225 12345 1234 Nowhere Dr Priest
1324562 225 123456 1234 Nowhere Dr Givens
1324562 225 1234567 1234 Nowhere Dr Bell
1324562 225 12345678 1234 Nowhere Dr Booth
So my question is how can I loop off all 3 elements(Address_Line_1,Account_ID, and Last_Name) instead of just 2? I have the variable list in the interate loop as Customer_Accounts, which returns the current last name and Account_ID but does not return the current Address.