Utilize pulldata to show multiple rows or "table"

418
1
08-07-2017 07:01 PM
OscarSepulveda_III
Occasional Contributor

I am wanting to utilize the #pulldata function to show multiple rows of data instead of just one.  The end user would choose a communications plan with the radio frequencies populating various functions.  

In the table below, if the user chose 'ALAMEDA', then listed would be the 'FUNCTION_RANK' followed by the 'FREQ_TYPE_ZONE_CH'.  Any help would be appreciated, as I want this form to work off one choice not multiple.

COMMPLAN

FUNCTION_RANK

FREQ_TYPE_ZONE_CH

ALAMEDA

COMMAND 1

LAC V3 VHF  [ ZONE: 1   CHANNEL: 3 ]  [ ZONE: 2   CHANNEL: 1 ]

ALAMEDA

COMMAND 2

LAC V4 VHF  [ ZONE: 1   CHANNEL: 4 ]  [ ZONE: 2   CHANNEL: 2 ] 

ALAMEDA

COMMAND 3

LAC V5 VHF  [ ZONE: 1   CHANNEL: 5 ]  [ ZONE: 2   CHANNEL: 3 ] 

ALAMEDA

CMD/TAC 1

VER V1 VHF  [ ZONE: 1   CHANNEL: 55 ]  [ ZONE: 2   CHANNEL: 4 ]

ALAMEDA

CMD/TAC 2

XLE V2 VHF  [ ZONE: 1   CHANNEL: 82 ]  [ ZONE: 2   CHANNEL: 5 ]

ALAMEDA

TACTICAL 1

VFIRE22 VHF  [ ZONE: 1   CHANNEL: 61 ]  [ ZONE: 2   CHANNEL: 6 ] 

ALAMEDA

TACTICAL 2

VFIRE23 VHF  [ ZONE: 1   CHANNEL: 62 ]  [ ZONE: 2   CHANNEL: 7 ] 

ALAMEDA

TACTICAL 3

VFIRE24 VHF  [ ZONE: 1   CHANNEL: 63 ]  [ ZONE: 2   CHANNEL: 8 ]

ALAMEDA

TACTICAL 4

VFIRE25 VHF  [ ZONE: 1   CHANNEL: 64 ]  [ ZONE: 2   CHANNEL: 9 ] 

ALAMEDA

TACTICAL 5

VFIRE26 VHF  [ ZONE: 1   CHANNEL: 65 ]  [ ZONE: 2   CHANNEL: 10 ] 

ALAMEDA

TACTICAL 6

VTAC11 VHF  [ ZONE: 1   CHANNEL: 56 ]  [ ZONE: 2   CHANNEL: 11 ]

ALAMEDA

TACTICAL 7

VTAC13 VHF  [ ZONE: 1   CHANNEL: 58 ]  [ ZONE: 2   CHANNEL: 12 ] 

FOOTHILL

COMMAND 1

ANF VHF  [ ZONE: 1   CHANNEL: 21 ]  [ ZONE: 3   CHANNEL: 9 ]

FOOTHILL

COMMAND 2

LAC V3 VHF  [ ZONE: 1   CHANNEL: 3 ]  [ ZONE: 2   CHANNEL: 1 ] 

FOOTHILL

COMMAND 3

LAC V4 VHF  [ ZONE: 1   CHANNEL: 4 ]  [ ZONE: 2   CHANNEL: 2 ] 

FOOTHILL

COMMAND 4

LAC V5 VHF  [ ZONE: 1   CHANNEL: 5 ]  [ ZONE: 2   CHANNEL: 3 ] 

FOOTHILL

COMMAND 5

LARTCS3V VHF  [ ZONE: 1   CHANNEL: 37 ]  [ ZONE: 7   CHANNEL: 5 ] 

FOOTHILL

TACTICAL 1

NIFC T1 VHF  [ ZONE: 3   CHANNEL: 11 ]  [ ZONE: 7   CHANNEL: 6 ] 

FOOTHILL

TACTICAL 2

NIFC T2 VHF  [ ZONE: 3   CHANNEL: 12 ]  [ ZONE: 4   CHANNEL: 11 ] 

FOOTHILL

TACTICAL 3

VFIRE22 VHF  [ ZONE: 1   CHANNEL: 61 ]  [ ZONE: 2   CHANNEL: 6 ] 

FOOTHILL

TACTICAL 4

VFIRE23 VHF  [ ZONE: 1   CHANNEL: 62 ]  [ ZONE: 2   CHANNEL: 7 ] 

FOOTHILL

TACTICAL 5

VFIRE24 VHF  [ ZONE: 1   CHANNEL: 63 ]  [ ZONE: 2   CHANNEL: 8 ] 

FOOTHILL

TACTICAL 6

VFIRE25 VHF  [ ZONE: 1   CHANNEL: 64 ]  [ ZONE: 2   CHANNEL: 9 ] 

FOOTHILL

TACTICAL 7

VFIRE26 VHF  [ ZONE: 1   CHANNEL: 65 ]  [ ZONE: 2   CHANNEL: 10 ]

FOOTHILL

AIR-to-GROUND 1

AG 59 VHF  [ ZONE: 3   CHANNEL: 14 ]  [ ZONE: 4   CHANNEL: 14 ] 

FOOTHILL

AIR-to-GROUND 2

LAC AG VHF  [ ZONE: 1   CHANNEL: 15 ]  [ ZONE: 2   CHANNEL: 16 ] 

FOOTHILL

AIR-to-GROUND 3

XLC AG VHF  [ ZONE: 1   CHANNEL: 80 ]  [ ZONE: 7   CHANNEL: 15 ]

FOOTHILL

EMERGENCY 1

AIR GUARD VHF  [ ZONE: 1   CHANNEL: 16 ]  [ ZONE: 3   CHANNEL: 16 ] 

FOOTHILL

COMMAND 1

ANF VHF  [ ZONE: 1   CHANNEL: 21 ]  [ ZONE: 3   CHANNEL: 9 ] 

0 Kudos
1 Reply
JohnathanHasthorpe
Esri Regular Contributor

Hi Oscar,

Pulldata will return a value from a single column only. To achieve the above, then you will need to create a new column in the .csv that contains a concatenated version of FUNCTION_RANK and FREQ_TYPE_ZONE_CH. You can then use pulldata to return this string to the user.

Regards

John

0 Kudos