Thanks for updating
However i could able to the same ,
just sharing in case any one from community need it
if(${work} = ‘1’,pulldata(‘recoveryupload.csv’, ‘branch’, ‘memecode_key’, ${ecode}),pulldata(‘odupload.csv’, ‘branch’, ‘memecode_key’, ${ecode_x}))
Above formula was used to pull data from two different external file basis pull method
Please check and guide in case i missed something ,if any
| type | name | label | required | relevant | appearance | calculation | read_only |
|---|---|---|---|---|---|---|---|
| start | start | ||||||
| end | end | ||||||
| today | today | ||||||
| username | username | ||||||
| simserial | simserial | ||||||
| subscriberid | subscriberid | ||||||
| deviceid | deviceid | ||||||
| phonenumber | phonenumber | ||||||
| select_one type | work | Please Select the Type of Working you are going to Start | true | ||||
| text | Loanid_r | Please Provide LAN Number of Any Member from Group | true | ${work} = ‘1’ | numbers | ||
| calculate | Loanid | false | string(${Loanid_r}) | ||||
| text | Loanid_x | Please Provide LAN Number of Any Member from Group | true | ${work} = ‘2’ | numbers | ||
| calculate | loanido | false | string(${Loanid_x}) | ||||
| begin_group | Group_Data | Branch Details | false | field-list | |||
| text | state | State | false | if(${work} = ‘1’,pulldata(‘recoveryupload.csv’, ‘state’, ‘memloanid_key’, ${Loanid}),pulldata(‘odupload.csv’, ‘state’, ‘memloanid_key’, ${Loanid_x})) | TRUE | ||
| text | areaoffice | Area Office Name | false | if(${work} = ‘1’,pulldata(‘recoveryupload.csv’, ‘areaoffice’, ‘memloanid_key’, ${Loanid}),pulldata(‘odupload.csv’, ‘areaoffice’, ‘memloanid_key’, ${Loanid_x})) | TRUE | ||
| text | branch | Branch Name | false | if(${work} = ‘1’,pulldata(‘recoveryupload.csv’, ‘branch’, ‘memloanid_key’, ${Loanid}),pulldata(‘odupload.csv’, ‘branch’, ‘memloanid_key’, ${Loanid_x})) | TRUE | ||
| text | villagename | Name of Village | false | ${work} = ‘2’ | pulldata(‘odupload.csv’, ‘villagename’, ‘memloanid_key’, ${Loanid_x}) | TRUE | |
| text | coname | Name of Credit Officer | false | if(${work} = ‘1’,pulldata(‘recoveryupload.csv’, ‘coname’, ‘memloanid_key’, ${Loanid}),pulldata(‘odupload.csv’, ‘coname’, ‘memloanid_key’, ${Loanid_x})) | TRUE |
Cheers!
Neeraj
