Forum Discussion
MakeMyTrip_Indi
14 years agoNew Contributor
The input data is in csv format which can have colums as "No. Of rooms","Adult count","Age". refer attachment.
Here "No. Of rooms" specify the no. of <RoomStayCandidate> </RoomStayCandidate> tags.
"Adult count" delimited value specifies the no. of <Age></Age> tags in each room.
"Age" specify the value of "Age" tag in each each room.(Delimiter comma gives value of each room. Again the delimiter @ gives the value of ages in each room)
So, for first room,
<RoomStayCandidates>
<RoomStayCandidate>
<GuestCounts>
<GuestCount count="2" ageQualifyingCode="10"/>
<GuestCount count="2" ageQualifyingCode="8">
<Ages>
<Age>21</Age>
<Age>22</Age>
</Ages>
</GuestCount>
</GuestCounts>
</RoomStayCandidate>
</RoomStayCandidates>
So, for second room,
<RoomStayCandidates>
<RoomStayCandidate>
<GuestCounts>
<GuestCount count="2" ageQualifyingCode="10"/>
<GuestCount count="1" ageQualifyingCode="8">
<Ages>
<Age>25</Age>
</Ages>
</GuestCount>
</GuestCounts>
</RoomStayCandidate>
</RoomStayCandidates>
So, for third room,
<RoomStayCandidates>
<RoomStayCandidate>
<GuestCounts>
<GuestCount count="2" ageQualifyingCode="10"/>
<GuestCount count="3" ageQualifyingCode="8">
<Ages>
<Age>43</Age>
<Age>23</Age>
<Age>31</Age>
</Ages>
</GuestCount>
</GuestCounts>
</RoomStayCandidate>
</RoomStayCandidates>
Here "No. Of rooms" specify the no. of <RoomStayCandidate> </RoomStayCandidate> tags.
"Adult count" delimited value specifies the no. of <Age></Age> tags in each room.
"Age" specify the value of "Age" tag in each each room.(Delimiter comma gives value of each room. Again the delimiter @ gives the value of ages in each room)
So, for first room,
<RoomStayCandidates>
<RoomStayCandidate>
<GuestCounts>
<GuestCount count="2" ageQualifyingCode="10"/>
<GuestCount count="2" ageQualifyingCode="8">
<Ages>
<Age>21</Age>
<Age>22</Age>
</Ages>
</GuestCount>
</GuestCounts>
</RoomStayCandidate>
</RoomStayCandidates>
So, for second room,
<RoomStayCandidates>
<RoomStayCandidate>
<GuestCounts>
<GuestCount count="2" ageQualifyingCode="10"/>
<GuestCount count="1" ageQualifyingCode="8">
<Ages>
<Age>25</Age>
</Ages>
</GuestCount>
</GuestCounts>
</RoomStayCandidate>
</RoomStayCandidates>
So, for third room,
<RoomStayCandidates>
<RoomStayCandidate>
<GuestCounts>
<GuestCount count="2" ageQualifyingCode="10"/>
<GuestCount count="3" ageQualifyingCode="8">
<Ages>
<Age>43</Age>
<Age>23</Age>
<Age>31</Age>
</Ages>
</GuestCount>
</GuestCounts>
</RoomStayCandidate>
</RoomStayCandidates>